Quick steps: 12 indexing tips in 12 minutes

This collection of "quick steps" -- or mini step-by-step tutorials -- will help get your SQL Server 2000 indexing efforts up and running in a jiffy, whether you want to create, view, query or rebuild indexes.

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

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close