SQL Server 2012: How to Write T-SQL Window Functions, Part 3

    Part 1: How to Use Microsoft SQL Server 2012's Window Functions Part 2: How to Write T-SQL Windows Functions This article is the last in a three-part series about SQL Server 2012's enhanced window functions. In the first two articles in the series, I focused on the logical aspects of window functions. I described window aggregate, offset, and distribution functions. In this final article, I focus on optimization of window functions. I provide indexing ...