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] IAM (Index Allocation Map) 2nd identifying lock resources IDENTITY property 2nd image data type implicit transactions In-Doubt Xact Resolution configuration option in-memory data pages in-row data pages included columns in indexes inconsistent analysis Index Allocation Map (IAM) 2nd Index Create Memory configuration option 2nd indexes actual vs. estimated size ALTER INDEX command B-trees 2nd 3rd changing options clustered clustered index node rows clustered index rows with uniqueifier computed columns constraints CREATE INDEX command vs. constraints CREATE INDEX options creating DBCC IND command detecting fragmentation disabling fragmentation fragmentation reports grouping included columns index row formats joining looking for rows managing overview modifying [See modifying indexes] nonclustered nonclustered index leaf rows nonclustered index node rows online index building organization overview 2nd partitioning placement rebuilding 2nd removing fragmentation reorganizing sorting space requirements special structure overview sys.system_internals_allocation_units view types of fragmentation uniqueness views 2nd information schema views initializing data files inserting index rows installations [See also upgrades] ASCII character set binary sorting Books Online character sets collation components [See components] Developer Edition disk space requirements editions Enterprise Edition Evaluation Edition Express Edition hardware requirements initial splash screen memory multiple instances on single computer named instances performance considerations pre-installation decisions overview prerequisites overview processors release notes security software requirements sort order overview sort order semantics specifying collation Standard Edition Upgrade Advisor user context Workgroup Edition instance name instant file initialization integer data types Integration Services integrity checks intent locks 2nd intermediate index pages internal fragmentation of indexes internal locking architecture lock blocks lock owner blocks lock partitioning number of slots in hash table overview syslockinfo table internal objects in tempdb database internal storage of tables allocation unit data storage metadata hobt (Heap Or B-Tree) in-row data pages LOB data pages overview querying catalog views row-overflow data row-overflow data pages sys.allocation_units view sys.indexes view sys.partitions view internal_object_reserved_page_count column is_fiber column is_media_read_only column is_name_reserved column is_online column is_percent_growth column is_preemptive column is_read_only column is_sparse column isolation in transactions isolation levels overview Read Committed isolation 2nd Repeatable Read isolation 2nd snapshot isolation [See snapshot isolation] Uncommitted Read isolation 2nd |