SQL Server Performance Forum – Threads Archive

query performance

How can I improve query performance in sql server 2005<br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]

---

That’s a really big question – that’s why this site is called SQL-Server-Performance.com Go to the start page of the site http://www.sql-server-performance.com/default.asp), and check the Articles section – there are two major ones on "auditing" performance that give you a good start. Then when you have specific questions, you post here in the forums.

---

maybe these sites help:
http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx
http://technet.microsoft.com/en-us/library/ms177411.aspx

---

I believe Adriaan has given you big solution with as simple as reply you need in this regard, improving performance is not a quick solution you can achieve. Performance tuning tools like in SQL 2005 that wasn’t available on past versions of SQL Server, when tuning was regarded as a black art. An index here, a few design changes there, toss in some query hints, do a quick SQL optimization and give you satisfaction of that you had a tuned database. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>