Exam Essentials


Know about the important DMVs.   Make sure you understand where to use the important DMVs and the output of each, such as sys.dm_exec_query_stats, sys.dm_db_index_ physical_stats, sys.dm_os_wait_stats, and sys.dm_tran_locks.

Understand index fragmentation.   Make sure you can interpret the fragmentation of an index and be able to decide whether corrective action is appropriate.

Be able to maintain indexes.   It is important to understand the difference between rebuilding and defragmenting an index and when to use each technique.

Know how to use query hints.   Make sure you understand the more “common” query hints such as INDEX ( index_val [ ,... n ] ) and others.

Understand read committed snapshot isolation and snapshot isolation.   It is important to understand how RCSI and SI work and where it is appropriate to use each.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net