Autoplay
Autocomplete
Previous Lecture
Complete and continue
Fundamentals of Parameter Sniffing
Before the Class
Prerequisites
Introductions and Overview (7:44)
Download the Slide Deck and Demos
Parameter Sniffing and Which Queries are Vulnerable
What Parameter Sniffing Is (27:11)
The Kinds of Queries That Are Vulnerable (32:46)
More Plan Choices, More Problems (24:12)
Lab: Write a Query That Suffers From Parameter Sniffing (3:36)
Lab: Reviewing Your Solutions (33:44)
When Parameter Sniffing Emergencies Strike (and Why)
The Usual Causes of Sniffing Emergencies (34:02)
The UNusual Causes (17:46)
How to React to a Sniffing Emergency (13:42)
Lab: React to a Sniffing Emergency (7:44)
Lab: Brent Does It (21:43)
Finishing Things Up
What Parameter Sniffing ISN'T (7:33)
How SQL Server 2022 Tries Fixing Parameter Sniffing (8:25)
Recap and Next Steps (2:01)
How to React to a Sniffing Emergency
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock