CHAPTER 7Optimizing Databases

In this chapter, you will learn about:

• Optimizing databases with indexes

• Optimizing indexes

• Statistics

• Full-text catalogs and indexes

• Database Engine Tuning Advisor (DTA)

• Index maintenance

• Database Console Command (DBCC)

• Use of filegroups

Architects know that some kinds of design problems are more personal than others. One of the cleanest, most abstract design problems is designing bridges. There your job is largely a matter of spanning a given distance with the least material. The other end of the spectrum is designing chairs. Chair designers have to spend their time thinking about human butts.

—Paul Graham

When optimizing a database, we need to think about design and how the database is used. ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.