Completed
Common Parameter-sensitive plan workarounds
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Built-in Intelligence with Azure SQL and SQL Server 2022 - Intelligent Query Processing and Database Features
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Query Store - Custom capture policies
- 3 What are Query hints?
- 4 Applying Query hints Today
- 5 Introducing Query Store hints
- 6 Using Query Store hints
- 7 Database Compatibility Level Family
- 8 Intelligent Query Processing Feature Family
- 9 Parameter-sensitive plan problem
- 10 Common Parameter-sensitive plan workarounds
- 11 Parameter Sensitivity Plan (PSP) optimization
- 12 Boundary value selection (Example of Real Estate agents portfolio)
- 13 Feedback Workflow
- 14 Memory Grant Feedback (MGF)
- 15 With MGF Percentile Grant
- 16 Parallelism today
- 17 Cardinality Estimation today
- 18 What is CE Feedback?
- 19 CE Feedback implementation
- 20 CE Feedback Scenarios (High Level) Correlation
- 21 Leveraging CE Feedback
- 22 Query compilation today
- 23 Optimized Plan Forcing using Query Store
- 24 Approximate QP: Approximate Percentile
