Indexing for Windowing Functions (45 minutes)

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

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.

Modules

Menu