Part 4: Performance Tuning
The chapters in Part 4 provide information to help you tune your SQL Server database:
Performance Tuning
Index Tuning Wizard