DPS 2020 Training Class – Performance-centric T-SQL – by Itzik Ben-Gan
Visit DPS 2020 More Training Classes Book Now
|
Pre-Con Title |
Performance-Centric T-SQL |
|
Track(s) |
Database Development |
|
Tags |
#TSQL #Performance #Optimization #QueryRewrites #WindowFunctions #QueryTuning #T-SQL |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
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/Topics |
|
|
Attendee Pre-requisite (if any) |
One year of experience writing T-SQL code and optimizing queries |
|
Is this class being recorded? |
No, this class will not be recorded. Therefore, no recordings will be available. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day). Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
