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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.