Oblivion (4/9/2014)
Koen Verbeeck (4/9/2014)
Another side effect from SSMS is that it has to display all the rows in the result set. It might do it not so efficiently as SSRS.(just a wild guess here)
Anyway, to really compare you would have to take a look at the execution plan and rule out caching as well.
I'm not sure how to check the execution plan for the procedure when it's called from Reporting Services as I've not looked at that before. Is there an easy way?
I think you can capture it using Profiler. (at least the query)
The plan might be retrieved from a DMV as well, but that's a bit out of my comfort zone.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP