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] B-trees deleting rows ghost records overview 2nd size backing up databases [See also restoring databases] backup types 2nd differential backups files and filegroups 2nd full backups logs moving databases overview partial backups restart recovery restore recovery backing up files and filegroups 2nd backing up logs backup devices backup types 2nd base tables best practices DBCC commands tempdb database binary data types binary sorting binding schedulers to CPUs bit data type Blocked Process Threshold configuration option 2nd blocking_exec_context_id column blocking_session_id column blocking_task_address column Books Online 2nd bound connections bracketed identifiers buckets_avg_length column buckets_avg_scan_hit_length column buckets_count column buckets_in_use_count column buckets_max_length column buckets_min_length column Buffer Manager buffer pools data cache memory configurations multiple instances on a single computer Non-Uniform Memory Access (NUMA) observing memory internals read-ahead memory mechanism sizing overview Target Memory value bulk update locks 2nd BULK_LOGGED recovery model |