The Real Self-Tuning Database

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Explore the self-tuning capabilities of SQL Server 2019 in this 57-minute conference talk from the PASS Data Community Summit. Dive into adaptive query processing features and Query Store's automatic plan regression fixes. Learn about Intelligent Query Processing, Adaptive Joins, Interleaved Execution, Memory Grant Feedback, Table Variable Deferred Compilation, Scalar Function Inlining, and Approximate Query Processing. Gain valuable insights into optimizing database performance and efficiency through SQL Server's advanced self-tuning mechanisms.

Syllabus

Intro
Technical Assistance
Thank you to our Presenting Sponsors
Intelligent Query Processing
Adaptive Joins
Interleaved Execution
Memory Grant Feedback
Table Variable Deferred Compilation
Scalar Function Inlining
Approximate Query Processing

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube