MP9004: Microsoft - Optimizing and Tuning Queries for Performance > Microsoft SQL Server 2005 Data Access MCITP 70-442

This course covers improving query performance in SQL Server 2005. 

Objectives:
Optimize and tune queries for performance
Evaluate query performance
Detect locking problems
Modify queries to optimize client and server performance
Rewrite subqueries to joins
Design queries that have search arguments
Convert single-row statements into set-based queries

Duration:
1 Hour