🚀 go-pugleaf

Top 10 SQL Server indexing tips to improve performance

�������,����Ļ���Ҫ�Լ�ȥ��վ�Ͽ�,ϣ�����а���

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1239952,00.h
tml

Significantly improve your SQL Server performance through proper indexing ch
oices. We've tallied our most popular tips on the topic of indexes so you'll
 be able to quickly get the answers to your indexing questions. Learn how to
 weed out valueless indexes, design high performing indexes and query your e
xisting SQL Server indexes. 

#1 -SQL Server 2000 indexing dos and don'ts 

In the second part of this three-part feature, Edgewood Solutions' Jeremy Ka
dlec outlines best and worst practices for indexing in SQL Server 2000. 

#2 -Indexes made handy in SQL Server 

Indexes should be reviewed to ensure prime performance. Weed out valueless i
ndexes in SQL Server, while identifying the best indexes for your applicatio
n. 

#3 -Partition indexes for improved SQL Server 2005 performance 

SQL Server 2005 index partitioning allows you to distribute the load for a g
iven index across multiple files. Learn how to create an index with partitio
ned data. 

#4 -Stored procedures: Create and delete constraints and indexes 

This collection of six stored procedures will help you create and delete con
straints and indexes. 

#5 -Tricks for using the Index Tuning Wizard 

Learn how to improve overall SQL Server 2000 performance with these Indexing
 Tuning Wizard tricks from Edgewood Solutions' Jeremy Kadlec. 

#6 -Undocumented stored procedure: Repair table indexes with sp_fixindex 

One undocumented stored procedure in SQL Server 2000 can be used to repair a
 corrupted table index. This tip explains how to use sp_fixindex to keep SQL
 Server running smooth. 

#7 -Undocumented stored procedure: Find space occupied by all tables and ind
exes 

Here's a quick way to find the space occupied by all tables and indexes in a
 SQL Server 2000 database. 

#8 -Solving SQL Server 2000 index fragmentation 

Edgewood Solutions' Jeremy Kadlec explains how indexes become fragmented and
 how to maintain beneficial indexes to ensure high performance. 

#9 -Indexing Q&A: Answers to your common indexing questions 

Know how to choose proper indexes for your business situation. In part one o
f this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers c
ommon indexing questions. 

#10 -Clustered and non-clustered indexes in SQL Server 

Rules for using a clustered vs. a non-clustered index are tough to decipher.
 In this tip, you'll see the fundamentals to consider when making your choic
e, along with some best practice techniques. Get an overview of tradeoffs an
d proper index implementation, as well as other areas involved in your decis
ion, including partitioning and storage arrays.
--

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.29]