Performance-Centric T-SQL by Itzik Ben-Gan

Performance-Centric T-SQL by Itzik Ben-Gan

$339.00

Performance-Centric T-SQL by Itzik Ben-Gan

Abstract: 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.

PS: This class will not be recorded. Therefore, no recordings will be available.

Date & Time:
View in your own time zone
Go to Training Class Page

Discount Code:
Get your 50% Discount Code – Click Here

Description

Performance-Centric T-SQL by Itzik Ben-Gan

Abstract: 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.

Modules:
Window functions
APPLY
OFFSET-FETCH
Optimization thresholds
Query rewrites
Intelligent QP / Adaptive QP
Approximate QP
String splitting and concatenation

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.