Tag Info

New answers tagged

6

Parameter sniffing means that one set of parameters produces a dramatically different execution plan than the other, and that if the wrong plan is cached, you get adverse performance effects. This answer is based on your simplified query - to get accurate advice for your query, you'll need to post the query and the two different plans that resulted from ...


0

Look here for a possible answer to this question. prevent sql injection inside stored procedure But the answer there is also a follow-up question.



Top 50 recent answers are included