Monday, February 23, 2009

Exam 70-442 Objective 5

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 5 (Performance Tuning a Database and a Database Application) and received only 32%.  I've got a bit of study to do, specifically:
  1. Optimize and tune queries for performance
    Creating Partitioned Views
    Table Hints (Transact-SQL)
    SET ANSI_PADDING (Transact-SQL)
    Introducing SQL Trace
    max degree of parallelism Option
  2. Optimize indexing strategies
    XML Best Practices
    Planning Guidelines for Partioned Tables and Indexes
    Creating Partitioned Tables and Indexes
  3. Scale database applications
    Creating Distributed Partitioned Views
  4. Resolve performance problems
    Dynamic Management Views and Functions (Transact-SQL)
    Performance Optimizations for the XML Data Type in SQL Server 2005
    sys.dm_os_wait_stats (Transact-SQL)
  5. Optimize data storage
    Data Normalization

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits)

No comments:

Post a Comment