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

YouTube

Intelligent Query Processing

PASS Data Community Summit via YouTube

Start learning Write review
Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More → DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session explains how SQL Server optimizer enhancements can address performance issues caused by common T-SQL patterns, including table variables and user-defined functions. It discusses when these features help and when they do not, without requiring code changes.

Syllabus

Introduction
Example
Interleave Execution
Inline Table Value
Multiline
Memory Grant Feedback
Memory Grant Feedback Example
Table Variable Deferred Compilation
Adventure Works
Batch Mode on Rowstore
Scalar UDF Inlining
Scalar UDF Demo
Approximate Count Distinct
Controlling IQP Features
Missing Table Example

Taught by

PASS Data Community Summit

Reviews

Start your review of Intelligent Query Processing

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.