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.
