Jonathan AC Roberts (11/26/2015)
If it is parameter sniffing causing the problem then you can just alter the stored procedure to copy the parameters passed in into ones created within the SP.
Which may work or may result in other problems. It's not a guaranteed fix. (Well, it'll fix the parameter sniffing, but it can cause other performance problems due to the lack of parameter sniffing)
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