P

Index

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

packages
     designing 2nd 3rd 4th 5th 6th 7th 8th
         logging
         SSIS expressions
         SSIS Object model 2nd 3rd 4th
    DTS 2000
         migrating to SSIS 2nd 3rd
PAE (Physical Addressing Extension)
page restoration
parallel index operations 2nd 3rd
parallel processing
     Service Broker solutions
parallelism
     query execution 2nd
PARAMETERIZATION hint
partition columns
Partition Process transformation
partitioning 2nd 3rd 4th 5th
partitioning indexes
partitions
     alignment
    rows
         ranking 2nd
passphrases
     encrypting/decrypting data 2nd 3rd
password policy support
     CREATE LOGIN DDL statement, options 2nd
     creating SQL Authenicated logins
     credentials
     disabling SQL Authenicated logins 2nd
     native password complexity
passwords
     creating
path expressions (XQuery)
PATH indexes
pausing
     database mirroring
peer-to-peer transactional replication 2nd
Performance Counters Correlation
performance enhancement tools
     DTA 2nd 3rd 4th 5th 6th 7th
     Performance Monitor, counters 2nd
     SQL Server 2005 Profiler
         blocked process report 2nd 3rd 4th 5th
         deadlock graphs 2nd 3rd 4th 5th
         features 2nd 3rd 4th
         XML showplans 2nd 3rd
Performance Monitor
     counters 2nd
         for Service Broker 2nd
performance tuning
     statement-level recompilation 2nd 3rd
performance, improving
     AUTO UPDATE STATISTICS ASYNC option 2nd
     DATE CORRELATION OPTIMIZATION option
     hyperthreading
     indexed views
     NUMA
performing database backups with SQL Server Management Studio
performing server administration with SQL Server Management Studio
permission buckets (SQLCLR)
     imported assemblies 2nd
permissions
     assigning to signed module users 2nd 3rd
     granular control
         ALTER permission
         CONTROL permission
         GRANT statement 2nd
         hierarchical permission model 2nd 3rd 4th
         IMPERSONATE permission
         object-scoped permissions
         server-scoped permissions
         TAKE OWNERSHIP permission
     granularity of in Analysis Services 2005 2nd
     levels of in .NET Framework 2nd
     VIEW DEFINITION
persisted computed columns 2nd 3rd
perspectives
physical database design
     covering indexes, creating 2nd 3rd
     indexes on computed columns, creating 2nd
piecemeal restoration
pipelines
PIVOT keyword 2nd
PIVOT relational operator 2nd
plan cache 2nd
plan guides 2nd 3rd 4th 5th
poison messages 2nd
precedence constraints
preemptive threading model
primary XML indexes 2nd 3rd 4th 5th
     internal representation 2nd
principal
principal database 2nd
prinicipal of least privileges
proactic caching
proactive caching
proactive performance monitoring
processes
processing
     cubes
processors
    32-bit
         AWE, limitations of
    64-bit
         addressable memory
         benefits of
     upgrading to 64-bit 2nd
Profiler 2nd
Profiler trace events
     for Service Broker 2nd
progress reporting (SSIS)
projects (SQL Server Management Studio)
prolog (XQuery)
properties
     accessing in Analysis Services 2005
properties of assemblies
     modifying
Properties window (BIDS)
PROPERTY indexes
property promotion 2nd
providers
     WMI
proxy accounts
public keys
     certificates