Главная
Study mode:
on
1
Introduction
2
Anxietyfree upgrades
3
Memory Grant Feedback
4
Query Execution Plan
5
Questions
6
Batch Mode
7
Batch Mode Demo
8
Regressions
9
BIWIN
10
MSSTDFs
11
MSSTDFs Demo
12
Adaptive Threshold
13
Initial Overhead
14
Compatibility Levels
15
Adaptive Joins
16
Does it have overhead
17
Adaptive Join
18
Adaptive Join with Hash Match
19
Reporting Threshold
Description:
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.

SQL Server and Azure SQL Database Intelligent Query Performance

PASS Data Community Summit
Add to list
0:00 / 0:00