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] Management Studio 2nd 3rd managing database security managing database snapshots managing indexes ALTER INDEX command changing index options detecting fragmentation disabling indexes fragmentation fragmentation reports online index building overview rebuilding indexes 2nd removing fragmentation reorganizing indexes types of fragmentation managing memory in other caches managing pages in data cache managing services manual database file expansion manual database shrinkage MARS (Multiple Active Result Sets) 2nd master database 2nd Max Degree Of Parallelism configuration option 2nd Max Full-Text Crawl Range configuration option Max Server Memory configuration option 2nd MAX specifier Max Text Repl Size configuration option Max Worker Threads configuration option 2nd max_size column maximum row length MAXSIZE file property Media Retention configuration option memory access to in-memory data pages Address Windowing Extensions (AWE) AWE Enabled option buffer pool checkpoints configuration options overview configurations data cache installation prerequisites Locks option management overview managing memory in other caches managing pages in data cache Max Server Memory option Memory Broker Min Server Memory option multiple instances on a single computer Non-Uniform Memory Access (NUMA) observing internals read-ahead Set Working Set Size option sizing sizing buffer pools overview Target Memory value User Connections option Memory Broker metadata catalog views changing compatibility views data storage information schema views layers of partitioning property functions system functions system stored procedures migrations Min Memory Per Query configuration option 2nd Min Server Memory configuration option 2nd mixed extents mixed_extent_page_count column model database creating new databases options overview modifying data types modifying databases modifying indexes data pages deleting rows from B-trees deleting rows in heaps deleting rows in node levels deleting rows overview forward pointers ghost records in-place row updates inserting rows intermediate pages locking logging moving rows not in-place row updates overview reclaiming pages root pages splitting pages table-level vs. index-level modifications updating rows modifying tables columns 2nd constraints data types metadata methods for overview rows triggers monitoring space in tempdb database moving databases moving index rows msdb database mssqlsystemresource database multi_pages_in_use_kb column multi_pages_kb column 2nd MULTI_USER database option Multiple Active Result Sets (MARS) 2nd multiple database files multiple editions multiple instances multiple physical log files multiple-statement transactions |
Категории