crashdan (4/10/2013)

---

smcguire (4/10/2013)

---

I recently discovered the original stored procedure that you referenced. The one issue that I have with it is the limitation that it runs on ALL databases!...

Hi Guys,

I did find out in the end what the actual reason was. Its Parameter Sniffing. I think basically SSRS sends through NULL values for the parameters for the query...

Not sure if you are still looking for a work around for this but I posted something here: http://www.sqlservercentral.com/Forums/Topic859015-150-1.aspx it might get you over the issue. I read on another...

I was able to find how I did this previously. I created a Temp table placed the values that we wanted to filter on in it then did an inner...

Not sure if your interested but I was reading an article just the other day on this issue which I think is a good solution for styles. It doesnt use...

I recall some time ago we had the same issue where we were passing in the parameters within SSRS to a SQL Dataset and it would slow it all down...