Book Excerpt

Quick steps: 12 indexing tips in 12 minutes

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: