Overview
Syllabus
Intro
Query Store - Custom capture policies
What are Query hints?
Applying Query hints Today
Introducing Query Store hints
Using Query Store hints
Database Compatibility Level Family
Intelligent Query Processing Feature Family
Parameter-sensitive plan problem
Common Parameter-sensitive plan workarounds
Parameter Sensitivity Plan (PSP) optimization
Boundary value selection (Example of Real Estate agents portfolio)
Feedback Workflow
Memory Grant Feedback (MGF)
With MGF Percentile Grant
Parallelism today
Cardinality Estimation today
What is CE Feedback?
CE Feedback implementation
CE Feedback Scenarios (High Level) Correlation
Leveraging CE Feedback
Query compilation today
Optimized Plan Forcing using Query Store
Approximate QP: Approximate Percentile
Taught by
SQLBits