Episode
SQL Server 2022: Accelerate query performance while reducing query compile time - with no code changes | Data Exposed
with Anna Hoffman, Derek Wilson
Learn more about the plan compilation features contained within SQL's Intelligent Query Processing offering, how they work, what common scenarios benefit from them, and how to get the most from them.
Chapters
- 00:20 - Introduction
- 00:44 - Optimized Plan Forcing explained
- 02:45 - Phases
- 03:30 - Demo
- 07:40 - How to take advantage of this feature
- 11:05 - Cautions
- 12:15 - Closing
Recommended resources
- Optimized plan forcing with Query Store | Microsoft Learn
- Parameter Sensitive Plan optimization | Microsoft Learn
Related episodes
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Learn more about the plan compilation features contained within SQL's Intelligent Query Processing offering, how they work, what common scenarios benefit from them, and how to get the most from them.
Chapters
- 00:20 - Introduction
- 00:44 - Optimized Plan Forcing explained
- 02:45 - Phases
- 03:30 - Demo
- 07:40 - How to take advantage of this feature
- 11:05 - Cautions
- 12:15 - Closing
Recommended resources
- Optimized plan forcing with Query Store | Microsoft Learn
- Parameter Sensitive Plan optimization | Microsoft Learn
Related episodes
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Video URL
HTML iframe
Azure SQL Database
SQL Server
SQL
Have feedback? Submit an issue here.