Microsoft SQL Server 2005 Data Access MCITP 70-442 Series: Optimizing and Tuning Queries for Performance
Product Code: l_mm07 Time: 1.0 hour(s) CEUs:

Summary:
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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

    Copyright Information:

    Trademark Information:

    Terms of Use:

    Copyright © 2008 MindLeaders. All rights reserved.