Index[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] PADINDEX setting 2nd partial database restores $PARTITION queries partitioning data indexes joins performance, improvements to tables advantages of ALTER DATABASE statements asymmetric design CREATE PARTITION FUNCTION statements CREATE PARTITION SCHEME statements data storage indexes $PARTITION queries row/column access patterns strategies for symmetric design table size views 2nd Partitioning Strategy to Employ section (DTA) PATH mode, FOR XML statements 2nd PDS (physical design structures), DTA PerfMon (Performance Monitor) [See System Monitor.] performance databases, DTA hardware, tuning operating systems, tuning partitioning, effects on SQL Server Activity Monitor baselines DBCC DTA dynamic management functions and views Log File Viewer readings/resources SNMP SQL Profiler System Monitor trace flags Performance event class (SQL Profiler) permissions 2nd Physical IO column (Activity Monitor) Playback feature (SQL Profiler) point-in-time data restorations positioned updates practice exams answer keys 2nd questions 2nd PRIMARY KEY constraints primary XML indexes Process ID column (Activity Monitor) Profiler (SQL) data captures data storage event class categories list lock events, trapping Playback feature Results window templates traces defining locking diagnosis example replaying workload sampling Progress Report event class (SQL Profiler) Prompt Before Restoring Each Backup option (Restore Database dialog) proxies publishers, role in replication central publisher and multiple subscribers strategies multiple publishers and multiple subscribers strategies multiple publishers and single subscriber strategies single publisher and a remote distributor strategies push/pull subscriptions, replication |