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.