New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

Exam 70-442 Objective 5

By James Hippolite, in , posted: 24-Feb-2009 13:51

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)
    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)

Other related posts:
Teach Yourself Azure in 4 hours
Geek Post Monthly Newsletter Volume 2 Issue 10

Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".