Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2013-03-22 : 14:17:23
|
| I have a query that runs for 1min.43sec. Im afraid this will take even longer on the SSRS reports.Any hints please to increase the performance of the query first.number of rows expected 80.000 but there are a lot of joins.Thanks!--------------------------Joins are what RDBMS's do for a living |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-25 : 04:48:19
|
| Also have alook at caching in ssrs reports. |
 |
|
|
|
|
|
Increase Query Performance for reports