A Slice of Time


Window functions are a powerful technique for analyzing data in SQL Server. In this session, we will understand when to use a window function like ROW_NUMBER() or LAG(), including specific use cases. We will understand the performance implications of window functions, including performance tuning of queries with window functions, using window functions to make certain classes of queries faster, and performance implications of having multiple windows in a single query. This talk will also review some of the limitations in SQL Server's implementation of window functions and how to work around many of these.


No recordings or additional media are available for this talk.