SQL Server and Azure SQL Database Intelligent Query Performance

Explore groundbreaking enhancements in Intelligent Query Processing for SQL Server 2019 and Azure SQL Database in this conference talk from PASS Data Community Summit. Delve into Microsoft's mission to improve critical parallel workloads at scale while adapting to the evolving data landscape. Learn about anxiety-free upgrades, memory grant feedback, query execution plans, and batch mode processing. Discover the benefits of adaptive thresholds, initial overhead considerations, compatibility levels, and adaptive joins. Gain insights into regression prevention, reporting thresholds, and the intelligent database world that began with SQL Server 2017 and advances significantly in SQL Server 2019 and Azure SQL Database.

Introduction
Anxietyfree upgrades
Memory Grant Feedback
Query Execution Plan
Questions
Batch Mode
Batch Mode Demo
Regressions
BIWIN
MSSTDFs
MSSTDFs Demo
Adaptive Threshold
Initial Overhead
Compatibility Levels
Adaptive Joins
Does it have overhead
Adaptive Join
Adaptive Join with Hash Match
Reporting Threshold