摘要：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... 阅读全文

摘要：create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20))exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'"select *... 阅读全文