摘要：
SQL Server 2000 and 2005 both use a "cost-based" optimizer to quickly locate data in its databases.Indexes are actually internal tables, and work like the index in a book – it contains a list of... 阅读全文
摘要：
ne of the most important knobs and levers you have in tuning a system from the database perspective is in your database'sindexes. The indexes you apply (or don’t apply) can create performance ga... 阅读全文
摘要：
ore than any other tuning you can perform; creating efficient queries will always give you the most return for your time and effort. I've managed to squeeze a few more percentage points of performance... 阅读全文