Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes

on YouTube ↗22m

" summary

Covers concrete IQP changes across SQL Server 2017/2019/2022 and Azure SQL: memory grant feedback persisted to Query Store (so learned grants survive cache eviction), interleaved execution gives exact cardinality for multi-statement TVFs, and adaptive join switches to hash match on the fly to avoid bad nested-loop plans; also parameter sensitive plan optimization (creates multiple child plans for skewed parameters), automatic DOP tuning, read-replica query-store support, and expected visible speedups without manual tuning.

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 3:16Query Store evolution
3. 6:09Adaptive Query Processing 2017
4. 9:23Top 5 intelligent features
5. 9:44Memory Grant Feedback deep dive
6. 13:18Interleaved Execution for TVFs
7. 16:34Adaptive Join optimization
8. 17:37Parameter Sensitive Plan Optimization
9. 19:47Degree of Parallelism optimization
10. 21:12Q&A

" related talks

• 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 MinutesHaider Raza, Manish Kumar · SQLBits 2019
• 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 MinutesHaider Raza, Manish Kumar · SQLBits 2022
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2023
• 50mBuilt-in Intelligence with Azure SQL and SQL Server 2022David Pless · SQLBits 2023
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2019
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2022
• 51mMaking the SQL Query Processor Work for youJoe Sack, Ajay Jagannathan, Derek Wilson · SQLBits 2022
• 44mImproving Performance with Intelligent Query ProcessingJohn Morehouse · SQL Server Virtual Conference 2021