This seminar covers advanced T-SQL querying and query tuning topics. It covers powerful querying tools like window functions, APPLY, OFFSET FETCH, and others; describing how they are optimized, and how you can use them to solve common practical T-SQL querying tasks like gaps and islands, handling intervals, Top N per group, and others. The seminar covers both classic query tuning topics like search arguments and join ordering optimization, as well as more recent additions to SQL Server and Azure SQL database like row mode versus batch mode processing, batch mode on rowstore, adaptive and intelligent query processing, deferred compilation, scalar UDF inlining, and more.

Presented by Itzik Ben-Gan at SQLBits 2020