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]

page allocation operations
page headers
page linkage in tables
page LSNs (log sequence numbers)
page-level locking vs. row-level locking
pages in indexes
     reclaiming
     splitting
PAGLOCK keyword
parameterization database options
parent_node_id column
partial backups
partitioning
     catalog views
     functions
     metadata
     overview
     schemes
     SWITCH option to ALTER TABLE command
pending_disk_io_count column
pending_io_byte_average column
pending_io_byte_count column
pending_io_count column
performance, sort order
pessimistic concurrency
PH_Timeout configuration option
phantoms
phases of recovery
physical_name column
pinning tables
placement of indexes
post-upgrade operations
pre-installation decisions [See also prerequisites for installation]
     ASCII character set
     binary sorting
     character sets
     collation
     multiple instances on a single computer
     named instances
     overview
     performance considerations
     release notes
     security
     sort order overview
     sort order semantics
     specifying collation
     Upgrade Advisor
     user context
precision
Precompute Rank configuration option
prerequisites for installations [See also pre-installation decisions]
     Developer Edition
     disk space requirements
     editions
     Enterprise Edition
     Evaluation Edition
     Express Edition
     hardware requirements
     initial splash screen
     memory
     overview
     processors
     software requirements
     Standard Edition
     Workgroup Edition
primary data files 2nd
primary filegroup
PRIMARY KEY constraint 2nd
principal vs. user
Priority Boost configuration option 2nd
processors
programmatic data integrity
progress reporting for database consistency
properties, database [See database options]
property functions
protocols
     configuring using Configuration Manager
     default
     Named Pipes
     overview
     Shared Memory
     system configurations
     tabular data stream (TDS) endpoints
     TCP/IP
     Virtual Interface Adapter (VIA)
pubs database



Inside MicrosoftR SQL ServerT 2005. The Storage Engine
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
Year: 2004
Pages: 115
Authors: Kalen Delaney

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