Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
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 |