Window functions usually are considered "advanced SQL", and while they're part of the language standard, SQL Server does not implement all of them. Version 2022 brought at least a small feature update worth looking at, so it's about time time to brush up our knowledge.

You will learn when and how how to use those OVER, PARTITION and ORDER clauses. From aggregate and ranking to statistical and offset functions, this session walks you through all that SQL Server offers, up to the new actual WINDOW clause. The demos will show real world applications, such as sliding means, running totals, string aggregates and even the popular "gaps and islands" problem.

Once you've got the hang of it (hopefully after this session), it will become clear that window functions are not overly complicated, but ease the development of data analysis in T-SQL, and in the optimal case even bring a performance advantage over conventional methods.