P

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

packages
Pad Index setting
PAGLOCK hint
parent-child dependency
partitioned views 2nd 3rd 4th 5th 6th
     indexing 2nd
PATINDEX() function
performance
     file placement 2nd
     RAID (redundant array of independent/inexpensive disks) 2nd
performance counter alerts 2nd
performance tuning 2nd 3rd 4th 5th
     concurrency 2nd 3rd
     Current Activity view 2nd 3rd 4th 5th 6th
     DBCC (Database Console Command) 2nd 3rd
         maintenance options 2nd
         miscellaneous options 2nd
         trace flags 2nd
         validation options 2nd
     Event Viewer 2nd
     exam prep questions 2nd 3rd 4th
     indexes 2nd
         clustered 2nd
         covering 2nd
         dropping 2nd
         full-text 2nd
         Index Tuning Wizard 2nd
         indexed views 2nd
         nonclustered 2nd 3rd
         rebuilding 2nd 3rd
         strategies 2nd
         what not to index 2nd 3rd
         what to index 2nd
     locks 2nd 3rd
         contention 2nd
         controlling lock behavior 2nd 3rd
         exclusive locks
         granularity
         shared locks
         transaction isolation levels 2nd
     partitioned views 2nd
         indexing 2nd
     Query Optimizer 2nd 3rd 4th
         execution plan caching and sharing 2nd
         hints 2nd 3rd 4th 5th 6th 7th 8th
         reading execution plans 2nd 3rd 4th 5th
     SQL Profiler 2nd 3rd
         diagnosing locking with 2nd 3rd
         templates
         traces 2nd 3rd 4th 5th 6th 7th
     statistical functions 2nd 3rd
     stored procedures 2nd 3rd 4th
         recompilation 2nd
         web applications and 2nd
     transactions 2nd 3rd
         atomicity
         beginning 2nd
         consistency
         durability
         isolation
         isolation levels 2nd
         rolling back 2nd
permissions
     object permissions 2nd 3rd 4th 5th 6th
     server roles
     statement permissions 2nd 3rd 4th 5th
physical databases [See databases]
PI() function
plus sign (+)
POWER() function
practice exam one 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
     answer key 2nd
practice exam two 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th
     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th
     answer key 2nd
Precision descriptor (columns)
primary files
PRIMARY KEY constraints 2nd 3rd 4th
Primary Key descriptor (columns)
primary keys 2nd
Priority Boost option (server properties)
procedure cache
2nd 3rd [See stored procedures]
     security 2nd
     sp_changedbowner
     sp_dboption
process information
     definition of
processes
     automation 2nd 3rd 4th
         alerts 2nd 3rd 4th 5th 6th
         jobs 2nd
         operators 2nd
     current activity, viewing 2nd 3rd 4th
Profiler
properties
     database properties 2nd
         ANSI_NULL_DEFAULT
         ANSI_NULLS
         ANSI_PADDING
         ANSI_WARNINGS
         ARITHABORT
         AUTO_CLOSE 2nd
         AUTO_CREATE_STATISTICS
         AUTO_SHRINK
         AUTO_UPDATE_STATISTICS
         CONCAT_NULL_YIELDS_NULL
         CURSOR_CLOSE_ON_COMMIT
         CURSOR_DEFAULT GLOBAL
         CURSOR_DEFAULT LOCAL
         MULTI_USER
         NUMERIC_ROUNDABORT
         OFFLINE
         QUOTED_IDENTIFIER
         READ_ONLY
         READ_WRITE
         RECOVERY BULK_LOGGED
         RECOVERY FULL
         RECOVERY SIMPLE
         RECURSIVE_TRIGGERS
         RESTRICTED_USER
         SINGLE_USER
         TORN_PAGE_DETECTION
         WITH termination (termination in italic) 2nd
     operating system service properties 2nd
     server properties
         Affinity Mask
         Allow Updates
         AWE Enabled
         C2 Audit Mode
         Cost Threshold for Parallelism
         Cursor Threshold
         Default Full-Text Language
         Default Language
         Fill Factor
         Index Create Memory
         Lightweight Pooling
         Locks
         Max Degree of Parallelism
         Max Server Memory
         Max Text Repl Size
         Max Worker Threads
         Media Retention
         Min Memory Per Query
         Min Server Memory
         Nested Triggers
         Network Packet Size
         Open Objects
         Priority Boost
         Query Governor Cost Limit
         Query Wait
         Reconfigure 2nd
         Recovery Interval
         Remote Access
         Remote Login Timeout
         Remote Proc Trans
         Remote Query Timeout
         Scan for Startup Process
         Set Working Set Size
         Two Digit Year Cutoff
         User Connections
         User Options
properties (databases)
     altering 2nd
publications
Publishers
     central Publisher, multiple Subscribers 2nd
     multiple Publishers, multiple Subscribers 2nd
     multiple Publishers, single Subscriber
     single Publisher, single Subscriber 2nd
Pubs database