In this chapter, you will learn about:
• Optimizing databases with indexes
• Optimizing indexes
• 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.
When optimizing a database, we need to think about design and how the database is used. ...