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
Topics:
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
