MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

Know how to perform database consistency checks.   Make sure you understand the various DBCCs and when to use them.

Understand index fragmentation.   It is important to understand index fragmentation and be able to analyze the output of the DBCC SHOWCONTIG command and the sys.dm_db_index_ physical_stats DMV.

Know how to rebuild indexes.   Make sure you understand the various techniques of rebuilding/ reorganizing indexes and when they are appropriate.

Understand multiserver administration.   Make sure you understand how to set up multi-server administration.

Be familiar with database maintenance plans.   Make sure you go through the Database Maintenance Plan Wizard to understand the various elements in a database maintenance plan.

Understand online operations.   Make sure you understand which online operations are available only in the Enterprise Edition of SQL Server 2005.

Know about the SSRS utilities.   Make sure you understand the various SSRS utilities and what they are responsible for doing.

Be familiar with SSRS encryption keys.   Make sure you understand the purpose of the encryption keys used by SSRS and the need to include them in your disaster recovery plan (DRP).

Report Execution in SSRS   Make sure you understand the effect of snapshots and cached reports on the system databases in SQL Server 2005.