D

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]

DAC (dedicated administrator connection)
data cache
     buffer pool
     managing pages
Data Definition Language (DDL)
data index pages
data integrity
data modifications in 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
     updating rows
data pages
    data rows [See data rows]
     DBCC PAGE command
     overview
     page headers
     row offset array
     viewing
data rows
     fixed-length
     in-row data
     LOB data
     maximum row length
     overview
     row offset array
     row-overflow data
     structure
     variable-length
data storage
     LOB data
     metadata
     sql_variant data
     varchar(MAX) data
data types
     approximate numeric values
     binary
     bit
     changing
     character
     choosing
     CLR
     cursor
     date
     datetime values
     decimal
     exact numeric values
     fixed-length
     globally unique identifier (GUID)
     image
     integer
     large object (LOB) 2nd
     ntext
     numeric
     overview
     precision
     rowversion
     scale
     single-byte characters (char and varchar)
     smalldatetime values
     sql_variant 2nd
     storage requirements
     table
     text
     time
     timestamp
     Unicode characters (nchar and nvarchar)
     uniqueidentifier
     universal unique identifier (UUID)
     user-defined
     varbinary
     varchar(MAX) data
     variable-length
database backups [See also database restores]
     backup types 2nd
     differential backups
     files and filegroups 2nd
     full backups
     logs
     moving databases
     overview
     partial backups
     restart recovery
     restore recovery
Database Consistency Checker [See DBCC commands]
Database Console Command [See DBCC commands]
database engine
     access methods
     clustering
     command parser
     components overview
     controlling utilities
     database manager
     full-text search
     observing engine behavior
     overview
     protocols
     query executor
     query optimizer
     query processor
     relational engine
     replication
     SQL manager
    SQL OS [See SQL operating system (OS)]
     storage engine
     tabular data stream (TDS) endpoints
     transaction services
database files
Database Mail XPs configuration option
database manager
database mirroring options
database options
     ANSI_NULL_DEFAULT
     ANSI_NULLS
     ANSI_PADDING
     ANSI_WARNINGS
     ARITHABORT
     auto 2nd
     AUTO_CLOSE
     AUTO_CREATE_STATISTICS
     AUTO_SHRINK
     AUTO_UPDATE_STATISTICS
     CHECKSUM
     CONCAT_NULL_YIELDS_NULL
     cursor 2nd
     CURSOR_CLOSE_ON_COMMIT {ON | OFF}
     CURSOR_DEFAULT {LOCAL | GLOBAL}
     database mirroring
     database recovery 2nd
     EMERGENCY
     emergency mode repair
     external access
     MULTI_USER
     NONE (No Page Verify)
     NO_WAIT
     NUMERIC_ROUNDABORT
     OFFLINE
     ONLINE
     other
     overview
     parameterization
     QUOTED_IDENTIFIER
     READ_ONLY
     RECURSIVE_TRIGGERS
     RESTRICTED_USER
     ROLLBACK AFTER integer [SECONDS]
     ROLLBACK IMMEDIATE
     Service Broker
     SINGLE_USER
     snapshot isolation
     SQL 2nd
     state 2nd
     sys.databases catalog view
     termination options
     TORN_PAGE_DETECTION
database owner
database recovery options 2nd
database restores [See also database backups, recovery]
     BULK_LOGGED recovery model
     example
     FULL recovery model
     migrating from earlier SQL Server versions
     moving databases
     overview
     pages
     partial restores
     recovery models
     restoring with standby files
     SIMPLE recovery model
database security
     authentication
     authorization
     database access
     databases vs. schemas
     default schemas
     login names
     managing
     namespace
     object
     overview
     principal
     securable
     separation of principals and schemas
     SQL Server authentication
     user
     Windows authentication
Database Services [See also database engine]
     clustering
     full-text search
     overview
     replication
database snapshots
     creating
     managing
     overview
     space used by
database_id column
databases
     AdventureWorks
     ALTER DATABASE examples
     altering
    backing up [See backing up databases]
     compatibility levels
    consistency [See DBCC commands]
     copying
     CREATE DATABASE example
     creating
    database engine [See database engine]
     database manager
    Database Services [See Database Services]
    DBCC commands [See DBCC commands]
     detaching and reattaching
     expanding
     FILEGROUP CREATION example
     filegroups
     files
     hidden
     locking
     master 2nd
    model [See model database]
     moving
     msdb
     mssqlsystemresource
     Northwind
    options [See database options]
     overview 2nd
    properties [See database options]
     pubs
     resource 2nd
    restoring [See restoring databases]
     sample
    security [See database security]
     shrinking 2nd
    snapshots [See database snapshots]
     space allocation
     system 2nd
    tempdb [See tempdb database]
data_space_id column
date data types
datetime values
DBCC commands
     best practices
     DBCC CHECKALLOC
     DBCC CHECKCATALOG
     DBCC CHECKDB
     DBCC CHECKTABLE
     DBCC SHRINKDATABASE
     DBCC SHRINKFILE
     overview
     progress reporting
     REPAIR options
     validation checks
     verifying Service Broker data
DBCC IND command
DBCC PAGE command
DBCC SHOWCONTIG function
DDL (Data Definition Language)
deadlocks
decimal data types
declarative data integrity
dedicated administrator connection (DAC)
DEFAULT constraint
default filegroup
Default Full-Text Language configuration option
Default Language configuration option
default network protocols
default schemas
default trace
Default Trace Enabled configuration option
deleting index rows
     B-trees
     ghost records
     heaps
     node levels
     overview
     reclaiming pages
delimited identifiers
detaching databases
Developer Edition
Development Tools
differential backups
dirty reads
disabling constraints
disabling indexes
disabling nonessential services
disabling triggers
Disallow Results From Triggers configuration option
disk I/O configuration options
disk space requirements
display name
DMFs (dynamic management functions)
DMVs (dynamic management views)
domain integrity
dropping columns
dropping constraints
durability in transactions
dynamic affinity
dynamic management functions (DMFs)
dynamic management views (DMVs)