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.