Significantly improve your SQL Server performance through proper indexing choices. 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 existing SQL Server indexes.
#1 -SQL Server 2000 indexing dos and don'ts
In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec 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 indexes in SQL Server, while identifying the best indexes for your application.
#3 -Partition indexes for improved SQL Server 2005 performance
SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files. Learn how to create an index with partitioned data.
#4 -Stored procedures: Create and delete constraints and indexes
This collection of six stored procedures will help you create and delete constraints 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 indexes
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 of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers common 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 choice, along with some best practice techniques. Get an overview of tradeoffs and proper index implementation, as well as other areas involved in your decision, including partitioning and storage arrays.
More information on this topic:
Expert answer: Index types in SQL Server 2005
Book excerpt: Quick steps: 12 indexing tips in 12 minutes
Book excerpt: Creating indexes using the Enterprise Manager
