Itzik Ben-Gan is a T-SQL trainer at and co-founder of Lucient. He is a Microsoft Data Platform MVP, author of many T-SQL books, and a regular speaker at SQL Server related conferences.
This session covers T-SQL Window Functions.
T-SQL window functions allow you to perform data analysis calculations like aggregates, ranking, offset and more. When compared with alternative tools like grouping, joins and subqueries, window functions have several advantages that enable solving tasks more elegantly and efficiently. Furthermore, window functions can be used to solve a wide variety of T-SQL querying tasks well beyond their original intended use case, which is data analysis. This session introduces window functions and their evolution from SQL Server 2005 to SQL Server 2017, explains how they get optimized, and shows practical use cases.