Tuning Window Functions in SQL Server

In this video, I show you various techniques you can use to make window functions faster, including proper indexing and usage of batch mode. I also demonstrate the performance difference between RANGE and ROWS.

LINKS AND INFO
Catallaxy Services - https://www.catallaxyservices.com
Demo Code - https://github.com/feaselkl/A-Slice-o...
A Slice of Time presentation - https://www.catallaxyservices.com/pre...
T-SQL Window Functions book - https://www.amazon.com/T-SQL-Window-F...
A Little About Joins and Windowing Functions in SQL Server -    • A Little About Joins And Windowing Functio...  
Query Plan Patterns For Windowing Functions: Indexes And Memory -    • Query Plan Patterns For Windowing Function...  
Indexing SQL Server Queries For Performance: Windowing Functions -    • Indexing SQL Server Queries For Performanc...  
A Little About Row & Range Window Functions vs Batch Mode in SQL Server -    • A Little About Row & Range Window Function...  
Window Functions in SQL Server: Part 3: Questions of Performance - https://www.red-gate.com/simple-talk/...