Window function performance in SQL Server: a complete guide

Learn everything you need to know about window function performance in SQL Server with SQL veteran Fabiano Amorim’s detailed three-piece guide series. Everything is covered, including (but not limited to):

  1. The basics of window functions – the history, what they are, etc;

  2. Why window functions are powerful (and so important to use);

  3. Window functions in various iterations of SQL Server over the years;

  4. The window function and window frame;

  5. Execution plans for running aggregates.

And much more! Here are the three guides for you to enjoy: