Optimize SQL Server without rewriting queries
Sluggish SQL Server database performance can be caused by many factors besides just poorly designed queries. While there is certainly a correlation between the quality of your queries and your server's performance, queries aren't always the problem when SQL Server underperforms. This article offers a variety of methods for optimizing a SQL Server box. Use them to address poor performance issues before adjusting your queries.