Home Forums SQL Server 2008 SQL Server 2008 - General SSMS 2008 Stored Proc WITH RECOMPILE RE: SSMS 2008 Stored Proc WITH RECOMPILE
MattW2010
SSCommitted
Points: 1532
More actions
April 5, 2010 at 9:25 am
#1145788
I just wanted to thank you guys for all your input. I added "optimize for unknown" to the sproc and the site is currently responding well.
I believe the parameter sniffing was the main issue.
Thanks again,
Matt