P



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




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

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