This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus.

The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. You will learn about features like the APPLY operator, window functions, the OFFSET-FETCH filter, and how to use them creatively to solve common T-SQL tasks elegantly and efficiently.

You will learn about optimization thresholds and understand how the query optimizer tends to choose between different algorithms, and how new intelligent/adaptive query processing capabilities enable SQL Server to make such choices dynamically during query execution.

The seminar also covers other recent and future-planned additions to T-SQL like system-versioned temporal tables, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, SQL Graph, batch mode over row store, adaptive joins, interleaved execution, deferred compilation, memory grant feedback, improvements in user-defined functions and more.

Half a year to a year of experience writing T-SQL code and optimizing queries.
Laptop Required:No

Presented by Itzik Ben-Gan at SQLBits XVIII