Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server and Azure SQL Database Intelligent Query Performance

PASS Data Community Summit via YouTube

Start learning Write review
TrainSec Ad

Learn EDR Internals: Research & Development From The Masters

Learn More → DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More →

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 enhancements in SQL Server 2019 and Azure SQL Database. It discusses memory grant feedback, batch mode, adaptive joins, compatibility levels, and query performance regressions.

Syllabus

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

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server and Azure SQL Database Intelligent Query Performance

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.