Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries

© Kathi Kellenberger, Clayton Groom, and Ed Pollack 2019

K. Kellenberger et al.Expert T-SQL Window Functions in SQL Server 2019https://doi.org/10.1007/978-1-4842-5197-3_1

1. Looking Through the Window

Kathi Kellenberger¹ , Clayton Groom² and Ed Pollack³

(1)

Edwardsville, IL, USA

(2)

Smithton, IL, USA

(3)

Albany, NY, USA

 

SQL Server is a powerful database platform with a versatile query language called T-SQL. The most exciting T-SQL enhancement over the years, in my opinion, is the window functions. Window functions enable you to solve query problems in new, easier ways and with better performance most of the time over traditional techniques. They are a great tool for analytics. You may hear these called “windowing” or “windowed” functions as well. The ...