Windowing functions give you great flexibility for analyzing data in SQL Server.
But how can you get the best performance for your windowing functions?
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
- Take a quick quiz to test your knowledge
Get the scripts
Each video in this course has English captions available, as well as a transcript below the video.