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