Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

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