LyraLearn AI Learning Platform
Exams
← SQL Server Performance Tuning
Module 5

Parameter Sniffing, Statistics, and 2022 Features

Why the same query is fast for one value and slow for another, and the 2022 fixes for it.

5.1
"Check Your Server Version First"
8 min
5.2
"Parameter Sniffing, Plainly"
12 min
5.3
"Fixes in Order of Bluntness"
13 min
5.4
"Statistics: Staleness and Updates"
11 min
5.5
"SQL Server 2022 Intelligent Query Processing"
14 min
5.6
"Query Store Hints: Fixing SQL You Cannot Edit"
10 min