AI, Data Science & Cloud Certificates from Google, IBM & Meta
The Most Addictive Python and SQL Courses
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session examines intelligent query processing features in Azure SQL and SQL Server 2022, including Query Store, parameter-sensitive plans, memory grant feedback, and cardinality estimation, with demonstrations of their effects on query performance.
Syllabus
Introduction
History of Intelligent Database
Query Store
Secondary Replicas
Parameter Sensitive Plans
ESP Optimization
Dispatcher Plan
Query Variants
Visual Representation
Demo
Force Unforced Plan
Memory Grant Feedback
Persistence
Velocity oscillation
Demonstration
Cardinality Estimation
C Feedback
Taught by
PASS Data Community Summit