Junaid Syed
What is parameter sniffing in SQL?
By Junaid Syed in SQL Server on Sep 07 2017
  • Manish Kumar
    Nov, 2017 17

    Parameter sniffing is basically a term where, for example there is a procedure and while executing this procedure with different parameter it will take same time (irrespective of no. of records return by that procedure.) mean to say that procedure has cached the old execution plan and that plan is getting used all time.To remove this we need to do few things. --Use WITH RECOMPLIE in procedure --Update old statistics --Use proc parameter as local variable inside procedure and assign to your condition

    • 2

Most Popular Job Functions