A Slice of Time: Indexing and Window Functions

This is part nine in a series on window functions in SQL Server. POC: the Rule of Thumb If you've been around the block with window functions, you've probably heard of the POC indexing strategy: Partition by, Order by, Covering. In other words, with a query, focus on the columns in the PARTITION BY clause…