JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
Option(Recompile). If that doesn't work, it's probably not simply a bad parameter sniffing problem. Can you post the code of the procedures? An execution plan showing the problem would also be very useful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability