If you're fairly new to the world of SQL Server indexing or you need a refresher on common indexing how-tos, these tips will get you up and running in a jiffy. Excerpted from the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation, by Thomas Moore and Ed Tittel, this collection of "quick steps" -- or mini step-by-step tutorials -- will help get your SQL Server 2000 indexing efforts running, whether you want to create, view, query or rebuild indexes.
The following collection of quick steps are excerpted from Chapter 10, 'Boosting Performance with Indexes.' For best practices and technical advice to accompany these tips view all of Chapter 10, 'Boosting Performance with Indexes.'
Quick steps: Boosting performance with indexes
- 1. Creating a clustered index using code
2. Creating indexes using the Enterprise Manager
3. Creating a nonclustered index in code
4. Viewing index information using sp_helpindex
5. Rebuilding all indexes using DBCC DBREINDEX
6. Querying and updating index statistics
7. Creating a trace
8. Creating an index with Index Tuning Wizard
9. Creating an indexed view
10. Using the Full-Text Wizard
11. Executing full-text searches using FREETEXT
12. Searching using CONTAINS
To download the complete chapter, click for the .pdf.
About the book
MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel is a study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. Each book in the Training Guide series is published under the direction of Series Editor Ed Tittel, the leading authority on IT certification. This book has been subjected to rigorous technical review by a team of industry experts. Click to purchase the book.
This was first published in January 2006