Training Class:- PERFORMANCE-CENTRIC T-SQL
This seminar covers advanced aspects of T-SQL 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. You will learn about the performance aspects of the Top N per group task, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, batch mode over row store, adaptive joins, interleaved execution, deferred compilation, memory grant feedback, improvements in user-defined functions and more.