Parameter Sniffing

I was recently having an issue with a SQL Report Query that would execute in management studio in a couple seconds¬† but when I ran the report the query would time out and never return results.¬†¬† Well it appears that the issue can be caused by “Parameter Sniffing”.

This website explains it and gives a solution.
http://elegantcode.com/2008/05/17/sql-parameter-sniffing-and-what-to-do-about-it/

This entry was posted in Blog, SQL Server Reporting Services (SSRS). Bookmark the permalink.

Comments are closed.