01. What Parameter Sniffing Is

We’ll start by defining what parameter sniffing is: a query that builds a dramatically different plan depending on what parameters are first used to compile it. We’ll begin with a query that uses literal values, show two different parameters that produce different plans, and show what happens when it’s put into a stored procedure. Demo…

We’ll start by defining what parameter sniffing is: a query that builds a dramatically different plan depending on what parameters are first used to compile it. We’ll begin with a query that uses literal values, show two different parameters that produce different plans, and show what happens when it’s put into a stored procedure. Demo...
Menu