O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required