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]

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