Can anybody give the guidelines for query optimization techniques as part of performence tuning in SQL server.Does it involves specific tasks to follow?.Thanks in advance..
I'm feeling bad about my last answer. In a nutshell:
This might not be the best way to answer this question, and if it's not, please just vote it down or delete it, but I can suggest a pretty good book on the topic: SQL Server 2008 Query Performance Tuning Distilled.
Originally posted a comment... but rather than delete it, and since I'm in the answer editor:
I defer to Grant for the SQL side to be sure.
Also make sure you look at things from a more physical aspect. Are your indexes, tables and temp dB competing for the same disk resources? Use PerfMon and check bytes/transfer, sec/transfer and queue lengths. Moving some files may give you a boost.
Check your network usage. Does the code require unnecessary trips from Client to Server and back?
Are there other applications or SQL instances competeing for RAM? Did you allow the O/S enough to get by without introducing paging?
1 Person is following this question.