Parameter sniffing is easy to spot and hard to pin down.
The optimizer picks a plan based on the first execution, and that choice can ripple across your workload in ways that are not always obvious.
A lot of that risk comes down to one decision: index seek with key lookups, or table scan. How your indexes are set up directly influences that choice.
Brent walks through how deliberate index tuning reduces that risk and shrinks the blast radius when things go sideways.
You’ll leave with a more practical way to think about sniffing, plan selection, and the indexing decisions behind both.