Measuring Database Performance
o Importance of Benchmarking
o Key Measures for Query Performance: Sysmon
o Key Measures for Query Performance: Profiler
o Guidelines for Identifying Locking and Blocking
Optimizing Physical Database Design
o Performance Optimization Model
o Schema Optimization Strategy: Keys
o Schema Optimization Strategy: Responsible Denormalization
o Schema Optimization Strategy: Generalization
Optimizing Queries for Performance
o Performance Optimization Model: Queries
o What Is Query Logical Flow?
o Considerations for Using Subqueries
o Guidelines for Building Efficient Queries
Refactoring Cursors into Queries
o Performance Optimization Model: Query-Set-based solutions
o Five Steps to Building a Cursor
o Strategies for Refactoring Cursors
Optimizing an Indexing Strategy
o Performance Optimization Model: Indexes
o Considerations for Using Indexes
o Best Uses of the Clustered Index
o Best Practices for Non-Clustered Index Design
o How to Document an Indexing Strategy
Managing Concurrency
o Performance Optimization Model: Locking and Blocking
o Multimedia - "How to Use Efficient Queries to Reduce Locking and Blocking"
o Strategies to Reduce Locking and Blocking
