Index P

[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]

parameters  
       BCP   2nd  
       BCP data import   2nd  
       BULK INSERT command   2nd  
       for BCP   2nd  
       named parameters   2nd  
       OPENROWSET function   2nd  
       passing and returning
               to user -defined functions   2nd   3rd  
       positional parameter passing  
PARSENAME  
partitioned views   2nd   3rd   4th   5th  
       creating   2nd   3rd   4th  
       federations  
       guidelines for   2nd   3rd  
       WHERE  
partitioning   2nd   3rd  
partitions
       creation strategies  
       creation strategy  
       multiple servers   2nd  
       NTFS  
       views   2nd   3rd  
passing
       parameters
               positional parameter passing  
               to user-defined functions   2nd   3rd  
pathing XML  
PDQ Lite
       database design software  
performance
       optimizing
               with views  
performance counter alerts   2nd  
performing
       replays of traces   2nd  
PERMISSIONS   2nd  
permissions
       object permissions   2nd   3rd  
       statement and object permissions   2nd   3rd  
       statement permissions   2nd  
physical design (of databases)
       file placement  
               RAID considerations   2nd   3rd  
               sequential versus random access   2nd   3rd   4th  
               system recoverability  
       recoverability  
               backup and disaster recovery  
               operating system service properties   2nd   3rd  
               recovery models   2nd   3rd   4th  
               standby servers  
               system and data recovery  
       space requirements   2nd  
               file growth strategies   2nd  
               shrinking files  
       system maintenance  
physical design of databases  
playing back traces   2nd  
       requirements   2nd   3rd   4th   5th  
playing back.   [See also replays]
populating databases
       Bulk Copy program  
positional parameter passing  
Practice Test mode (PrepLogic practice test)  
        buttons  
Practice Test mode (PrepLogic practice tests)
       starting a session  
pre-testing   2nd  
precedence
       UNION operator  
preparing
       XML documents   2nd  
PrepLogic
       contacting  
PrepLogic Exam Competency (PrepLogic practice tests)  
PrepLogic practice tests
       buttons  
       customized tests  
       Examination Score Report  
       Flash Review mode
               starting a session  
       installing  
       interface design   2nd  
       modes  
       options  
       Practice Test mode
               starting a session  
       preconfigured tests  
       PrepLogic Exam Competency Score  
       reviewing the test  
       software requirements  
       timed tests  
       uninstalling  
prerequisites
       for indexed views   2nd   3rd   4th  
preventing
       updates
               to cursors  
primary files  
       default names  
PRIMARY KEY  
Primary Keys   2nd   3rd   4th   5th  
primary keys  
Primary Keys
       as clustered indexes  
       constraints   2nd  
priming read  
PRINT statement   2nd  
proactive optimization
       SQL Query Optimizer  
               alerts  
               Database Maintenance Plan Wizard  
               jobs  
               operators   2nd   3rd  
               performance counter alerts   2nd  
PROC  
procedural business logic
       stored procedures
               enforcing   2nd   3rd   4th   5th  
       user-defined functions
               enforcing   2nd  
procedure cache  
process information
       Current Activity window   2nd   3rd  
profile traces
       defining   2nd   3rd   4th   5th  
       to diagnose locking   2nd  
Profiler utility   2nd  
properties
       databases
               altering  
       of columns   2nd   3rd  
       operating system service   2nd   3rd  
properties.   [See attributes]
publications
       setting up   2nd   3rd   4th   5th   6th   7th  
Publisher  
Publisher/Subscriber metaphor   2nd  
       articles  
       Distributor  
       partitioning   2nd  
       Publisher  
       Subscriber  
       subscriptions  
Pubs database
       databases
               Pubs  
pulling
       subscriptions   2nd   3rd   4th