Microsoft® SQL Server 2008 R2 Unleashed

Chapter 34. Data Structures, Indexes, and Performance

IN THIS CHAPTER

• What’s New for Data Structures, Indexes, and Performance

• Understanding Data Structures

• Database Files and Filegroups

• Database Pages

• Understanding Table Structures

• Understanding Index Structures

• Data Modification and Performance

• Index Utilization

• Index Selection

• Evaluating Index Usefulness

• Index Statistics

• SQL Server Index Maintenance

• Index Design Guidelines

• Indexed Views

• Indexes on Computed Columns

• Filtered Indexes and Statistics

• Choosing Indexes: Query Versus Update Performance

• Identifying Missing Indexes

• Identifying Unused Indexes

A number of factors affect SQL Server performance. One of the key factors is your table and index design; ...