November 18, 1999 02:37 PM
Nine Ways to Optimize SQL Server 6.5 Queries
Rating:
(0)
SQL Server Magazine
InstantDoc ID #7631
What a difference an index can make! I received that reminder recently when I added an index and changed a query's runtime from 40 minutes to 12 seconds. Indexing, however, is only one tool in a DBA's performance-tuning toolkit. You can get better performance by configuring everything from your hardware to your database options. Here are my top nine ways to performance-tune SQL Server 6.5.
1. ...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: