A

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