Get better SQL Server performance before you improve the queries
April 4, 2005[From Builder.com]
When looking at SQL performance there's an immediate desire to jump into the queries that the SQL Server is being forced to process and see what can be done to improve them. Unfortunately, it's not always that simple. Sometimes the queries are coming from packaged software that cannot be changed. Other times the queries come from report writing tools and there's just no way to make the queries any better.
It's those times when it's critical to take a look at the server you have and figure out if it's really running as fast as it can.
The article continues at http://builder.com.com/5100-6388_14-5596494.html?tag=sc