22-25 April 2026 
SQLBits 2018
Window Functions
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.
Speakers
Itzik Ben-Gan's previous sessions
Beware of nondeterministic T-SQL code
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
T-SQL tips and tricks focusing on backdoors and workarounds
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
Ordering woes
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
Window Functions
This session covers T-SQL Window Functions.
Boost your T-SQL with the APPLY Operator
The session starts with a brief overview of the operator and it
T-SQL Tips and Tricks
The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.