Paresh Motiwala (6/11/2013)
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?
Warmest Regards
Paresh Motiwala
Boston
There is pretty much nothing anybody can do to help based on the lack of any details. It seems you have some sort of performance issue with your query. Please see this article on how to post performance problems.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/