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 |
|
kasaya
Starting Member
10 Posts |
 Posted - 2009-10-16 : 07:10:00
|
| Hi,can i ask something...i am editing an existing query that have a record counting to 1 million and still growing...and it cause a time out error on the front end...it have many temp tables and joining inside and some clustered index...what can you suggest to resolve my simple problem :)hope you can understand my problem :)) thanks a lot |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-16 : 07:19:28
|
There is no general answer to this.To solve performance problems is more a kind of art...I found this "checklist" as an approach:There is at least one point missing: "poor written queries".http://www.sqlcommunity.com/default.aspx?tabid=77&id=235
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
kasaya
Starting Member
10 Posts |
Posted - 2009-10-16 : 07:33:03
|
| thanks webfred...ill read the article :) |
|
|
|
|
|
|
Fast Query Recommendation