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] access methods databases in-memory data pages overview row and index operations ACID properties active virtual log files (VLFs) active_workers_count column Ad Hoc Distributed Queries configuration option adding columns adding constraints Address Windowing Extensions (AWE) memory advanced configuration settings AdventureWorks database 2nd Affinity column Affinity I/O Mask configuration option 2nd Affinity Mask configuration option 2nd Affinity64 I/O Mask configuration option 2nd Affinity64 Mask configuration option 2nd Agent XPs configuration option allocation optimizations in tempdb database allocation unit ALLOCATION_UNIT locks Allow Updates configuration option ALTER COLUMN clause ALTER DATABASE command ALTER DATABASE examples ALTER INDEX command ALTER TABLE command columns 2nd constraints data types overview SWITCH option triggers variations altering databases altering tables columns 2nd constraints data types metadata methods for overview rows triggers analysis recovery phase Analysis Services ANSI_NULL_DEFAULT database option ANSI_NULLS database option ANSI_PADDING database option ANSI_WARNINGS database option application locks approximate numeric values architecture access methods access to in-memory data pages buffer pool checkpoints command parser components overview controlling utilities data cache database manager managing memory in other caches managing pages in data cache Memory Broker memory management overview observing database engine behavior overview protocols query executor query optimizer relational engine sizing buffer pools sizing memory SQL manager SQL OS [See SQL operating system (OS)] storage engine tabular data stream (TDS) endpoints transaction services ARITHABORT database option ASCII character set associated entity ID atomic transactions atomicity in transactions attributes authentication authorization auto database options 2nd AUTO_CLOSE database option AUTO_CREATE_STATISTICS database option automatic database file expansion automatic database shrinkage automatic truncation of virtual log files (VLFs) AUTO_SHRINK database option autoshrink database property AUTO_UPDATE_STATISTICS database option AWE (Address Windowing Extensions) memory AWE Enabled configuration option 2nd awe_allocated_kb column |