O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide 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 7 Optimizing Databases

In this chapter, you will learn about:

• Optimizing databases with indexes

• Optimizing indexes

• Statistics

• Full-text catalogs and indexes

• Database Engine Tuning Advisor

• Index maintenance

• Database Console Command (DBCC)

• Use of filegroups

The art of being wise is the art of knowing what to overlook.

—William James

Whenever you're tasked with optimizing a database, looking at the indexes is typically where you'll find you can get the best gains. Knowing when to use a clustered index, when a nonclustered index will work, and how to maintain the indexes can help you significantly improve performance of many databases.

Many tools are available to help us optimize a database. Knowing which tools to use for ...

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