Tuning Window Functions in SQL Server

Published: 14 October 2025
on channel: Kevin Feasel
117
3

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/...


On this page of the site you can watch the video online Tuning Window Functions in SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Kevin Feasel 14 October 2025, share the link with friends and acquaintances, this video has already been watched 117 times on youtube and it was liked by 3 viewers. Enjoy your viewing!