I have a report that ran fine prior to upgrade to sql 2008 R2 SP1.
It has 3 parameters.
1. to select people,
2. to select date.
3. is default(run date)
when we run this report for one person, it works fine. But when we run it for "all" people, it times out.
it basically runs a stored procedure in the back, xxx ,' all', 'date', Default
If I run the stored proc, it takes 47 seconds to get all results.
So something changed in the R2/SP1 that messed this up.
We have no answers .....
Can anybody help?
DBA, Project Manager, Big Data Enthusiast