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.

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

Comments are closed.