A Slice of Time
ABSTRACT
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.ADDITIONAL MEDIA
No recordings or additional media are available for this talk.SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.
LINKS & FURTHER INFO
Helpful Resources
- I am indebted to Itzik Ben-Gan for the outstanding work he has done around teaching window functions. Go out and buy a copy of his window functions book; I guarantee it's worth the money.
- Erik Darling is another person in the space doing outstanding work. Check out a series of blog posts starting with this one and moving forward for query tuning and batch mode techniques I reference during my talk, as well as several advanced techniques I didn't have the time to cover.