Get the best performance for your windowing functions.
Windowing functions give you great flexibility for analyzing data in SQL Server, but can be tricky to index.
In this course, you will:
- Learn index design for windowing functions
- Learn when batch mode may be important for window function performance
- Compare the performance of Window Spool and Window Aggregate operators
Get the scripts
https://github.com/LitKnd/SQLWorkbooks/tree/main/indexing_for_windowing_functions
Each video in this course has English captions available, as well as a transcript below the video.