Product has been added to your cart.

Parameter Sniffing

  1. Home
  3. Development
  5. Parameter Sniffing
    6. (Page 3)
Plan Guides are like duct tape

Stabilizing Execution Plans: Plan Guides and NORECOMPUTE

Kendra Little
Execution Plans, Parameter Sniffing, SQL Server
14 Comments
What could go wrong? Sometimes you end up in a good plan / bad plan situation: an important query runs just fine most of the time. The query is parameterized, a good execution plan gets re-used, everything is cool. But sometimes, a “bad plan” gets compiled and starts to be reused. This is “bad” parameter sniffing. “Bad plans” can…
Read More

Why You’re Tuning Stored Procedures Wrong (the Problem with Local Variables)

Kendra Little
Parameter Sniffing, SQL Server
20 Comments
There’s an important rule for tuning stored procedures that’s easy to forget: when you’re testing queries from procedures in SQL Server Management Studio, execute it as a stored procedure, a temporary stored procedure, or using literal values. Don’t re-write the statemet you’re tuning as an individual TSQL statement using local variables! Where it goes wrong…
Read More

Optimize for… Mediocre?

Kendra Little
Parameter Sniffing, SQL Server
36 Comments
Some query hints sound too good to be true. And, unfortunately, usually they aren’t quite as magical as they might seem. Frustration with unpredictable execution times People often learn about parameter sniffing when query execution times stop being predictable. Occasionally you’ll hear about a stored procedure taking much longer than normal, but the next time…
Read More