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