Index D

[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]

data columns , traces   2nd   3rd   4th   5th  
data files
       primary data files   2nd   3rd   4th  
       secondary data files   2nd  
data integrity   2nd  
       database engine and   2nd  
       declarative data integrity  
       domain integrity  
       enforcing   2nd  
       entity integrity  
       procedural data integrity  
       referential integrity  
data manipulation
       deleting rows  
               from heap   2nd   3rd   4th   5th  
               from index   2nd   3rd   4th   5th  
               reclaiming space  
       updating rows  
               forward pointers   2nd   3rd  
               in place updates   2nd  
               not in place updates   2nd   3rd  
data mapping
        attribute-centric  
data mining  
       algorithms   2nd  
       AS   2nd   3rd   4th   5th   6th   7th  
data modification
       inserting data   2nd   3rd   4th   5th   6th  
       views and   2nd   3rd  
data pages  
       data rows   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th  
       page header   2nd   3rd  
       row offset table   2nd   3rd   4th  
data pump, DTS   2nd  
       Multiphase Data Pump  
data retrieval
       FOR XML clause and   2nd  
       simplification, views   2nd   3rd   4th  
       XML binary data   2nd   3rd   4th  
data rows
       images   2nd   3rd  
       text   2nd   3rd  
data rows, pages   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th  
data storage   2nd  
data warehouses
       design methodology   2nd   3rd  
data warehousing
       query optimization and   2nd   3rd  
data-driven queries   2nd  
DataAdapter object, ADO.NET  
database catalog  
database catalog tables   2nd  
database connection pooling, MTS   2nd   3rd   4th  
Database Consistency Checker  
Database Diagrams
       index creation  
database engine   2nd  
       data access   2nd   3rd  
       data integrity   2nd  
       security  
       storage   2nd   3rd  
Database Engine Edition
       licensing  
Database Integrity screen, maintenance wizard   2nd  
Database Maintenance Plan Wizard   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
Database Maintenance Plans   2nd  
database management  
       file growth   2nd  
database options   2nd  
Database Properties window  
database roles
       Enterprise Manager and   2nd  
       stored-procedures  
       T-SQL and   2nd  
DATABASEPROPERTYEX function  
databases   [See also VLDB]
       AS and  
        backups   2nd   3rd   4th   5th   6th   7th  
               disk   2nd  
               Enterprise Manager   2nd   3rd   4th   5th   6th  
               system database   2nd   3rd  
               T-SQL   2nd   3rd   4th   5th   6th  
               very large databases  
       corrupt   2nd   3rd  
       creating   2nd   3rd  
               Create Database Wizard   2nd  
               Enterprise Manager   2nd   3rd   4th   5th   6th  
               T-SQL   2nd   3rd  
       design
               denormalization   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
       development environment   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       differential backups   2nd  
       dimensional  
       distribution  
       expanding   2nd  
       extents  
       files   2nd   3rd   4th   5th   6th   7th   8th  
       full database backup   2nd  
       logical database design   2nd   3rd   4th   5th   6th   7th   8th  
       maintenance history  
       master  
       model  
       modifying
               Enterprise Manager   2nd   3rd  
       msdb  
       naming   2nd  
       Notification Services and  
       object placement, secondary data files and  
       OLAP
               building cubes   2nd   3rd  
               calculated members   2nd   3rd  
               creating   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st  
               cube processing   2nd  
               datasources   2nd  
               dimensions   2nd   3rd   4th   5th   6th   7th   8th   9th  
               measures   2nd   3rd   4th   5th  
               storage design   2nd   3rd   4th   5th  
       overview   2nd   3rd  
       pages  
       pages.   [See pages, databases]
       permissions
               Notification Services   2nd   3rd  
       primary files  
       RDBMS (relational database management system)
               client/server architecture   2nd  
       relational databases   2nd   3rd   4th   5th   6th   7th   8th   9th  
               limitations  
       report generation, maintenance  
        restores   2nd   3rd   4th  
               partial   2nd  
               to different databases  
       restoring   2nd   3rd   4th   5th   6th   7th   8th  
               T-SQL   2nd   3rd   4th   5th  
       secondary files  
       shrinking   2nd   3rd   4th   5th   6th  
       stored procedures
               performance improvements  
       system databases
               restores   2nd   3rd   4th   5th  
       temdb  
DataColumn object, ADO.NET  
DATALENGTH function  
DataReader object, ADO.NET  
DataRow object, ADO.NET  
datasets
       ADO.NET   2nd   3rd   4th  
datasources
       AS and  
       OLAP databases   2nd  
       remote
               linked servers   2nd   3rd   4th  
datasources (ODBC)
       configuration  
DataTable object, ADO.NET  
datatypes
       BCP utility and   2nd   3rd  
       bigint   2nd  
       binary   2nd   3rd  
       bit  
       changing
               columns   2nd   3rd  
       character   2nd   3rd  
        cursors
               stored procedures  
       datetime   2nd   3rd  
       domain integrity  
       hierarchy   2nd  
       numeric
               approximate  
               exact  
               integer datatypes   2nd  
               money  
               special  
       sql variant   2nd  
       synonyms   2nd  
       system-supplied  
       T-SQL
               bigint   2nd  
               sql_variant   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               table   2nd   3rd  
       table  
               stored procedures   2nd   3rd   4th   5th   6th   7th  
       tables and  
       timestamp  
       uniqueidentifier   2nd  
        user -defined   2nd   3rd  
                names  
date functions   2nd   3rd   4th  
datediff ( ) function, query run time   2nd   3rd   4th   5th  
datetime datatypes   2nd   3rd  
DB-Library applications  
DBCC
       enhancements  
       trace flags  
DBCC (Database Consistency Checker)  
DBCC (Database Console Commands)   2nd   3rd   4th   5th  
DBCC CHECKDB statement  
DBCC CHECKTABLE  
DBCC command
       performance monitoring and   2nd   3rd   4th   5th   6th   7th  
DBCC PERFOM command  
DBCC PROCACHE commands   2nd   3rd  
DBCC SHRINKDATABASE statement  
DBCC SHRINKFILE command  
DBCC SHRINKFILE statement   2nd   3rd  
DBCC_INDEXDEFRAG  
dbo account
       security  
DCL (Data Control Language)  
DCM (Differential Changed Map) pages   2nd  
DCOM
       configuration   2nd   3rd  
DCOM (Distributed COM)  
DDL
       ALTER_TABLE  
       CREATE_TABLE  
DDL (Data Definition Language)  
       commands  
       CREATE_DATABASE  
deadlocks   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd  
deallocating
       cursors
               stored procedures  
deallocation
       cursors   2nd  
debugging   2nd   3rd  
       DCOM configuration   2nd   3rd  
       debugger limitations   2nd  
       stored procedures   2nd  
               Query Analyzer   2nd   3rd  
               Visual BASIC   2nd   3rd  
               Visual Studio   2nd   3rd  
       T-SQL Debugger   2nd   3rd  
               Query Analyzer   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       triggers  
       user functions  
declarations
       cursors   2nd   3rd   4th   5th   6th  
        variables
               cursors and   2nd  
declarative data integrity  
declarative defaults  
DECLARE statement
       local variables  
       table datatype  
DECLARE statements
       functions and  
DEFAULT constraint  
default language, configuration  
defaults  
       applying   2nd   3rd  
       binding
               precedence   2nd   3rd  
       bound defaults   2nd  
       declarative  
       names   2nd  
       restrictions   2nd  
       usage   2nd  
deferred name resolution  
deferred name resolution, stored procedures   2nd   3rd   4th   5th   6th   7th   8th  
deferred updates, rows  
DELETE permission  
Delete physical operator, Query Analyzer  
DELETE statement   2nd  
       functions and  
       linked servers and  
       T-SQL   2nd  
Deleted Scan operator, Query Analyzer  
deleted tables
       triggers and   2nd   3rd   4th   5th   6th  
delivery protocol, Notification Services  
denormalization   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
densities , indexes   2nd   3rd  
DENY command  
deployment
       instances, Notification Services   2nd   3rd   4th   5th   6th   7th  
derived tables
       subqueries as   2nd  
design
       denormalization   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
       indexes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
               clustered   2nd   3rd   4th  
               composite indexes and multiple indexes   2nd  
               index covering   2nd   3rd   4th   5th   6th  
               nonclustered   2nd   3rd   4th   5th  
       logical database design   2nd   3rd   4th   5th   6th   7th   8th  
       methodology   2nd   3rd  
       normalization, forms   2nd   3rd   4th   5th   6th  
       performance and   2nd   3rd  
       RAID technology   2nd   3rd   4th   5th   6th   7th  
       replication, user requirements and   2nd   3rd   4th   5th  
Desktop Engine   2nd  
deterministic functions   2nd  
Developer Edition   2nd  
development environment   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
dictionary entries, English Query applications   2nd   3rd  
       read synonyms  
       words  
       write synonyms  
differential database backups   2nd  
Dimension Wizard, AS  
dimensional databases  
dimensions
       AS and  
dimensions, OLAP databases   2nd   3rd   4th   5th   6th   7th   8th   9th  
Direct Recursion, triggers  
directories
       base, server name   2nd  
       naming standards  
dirty reads, isolation levels and  
disabling constraints   2nd   3rd  
disk activity
       Performance Monitor   2nd   3rd  
disk backups
       compared to tape backups   2nd   3rd  
disk I/O  
       asynchronous I/O   2nd  
       Merry-Go-Round scans   2nd  
       read aheads   2nd   3rd  
        scatter-gather I/O   2nd  
disk management, on-demand   2nd   3rd  
disk space requirements   2nd  
disk system, Performance Monitor and   2nd   3rd   4th   5th   6th   7th   8th   9th  
disks
       backups   2nd   3rd   4th  
DISTINCT keyword
       aggregate functions  
DISTINCT, query optimization and  
distributed databases  
distributed partitioned views  
Distributed Partitioned Views   2nd  
distributed queries   2nd   3rd   4th  
       linked servers   2nd   3rd   4th  
distributed transactions   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       linked servers   2nd  
       MS DTC, architecture   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th  
       performance monitoring   2nd  
       two-phase commit protocol   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th  
Distribution Agent  
       transactional replication  
distribution agent (replication)   2nd  
       transactional replication  
Distribution Clean Up agent  
distribution database  
       replication and   2nd   3rd  
distribution methods
       replication and   2nd   3rd  
distribution server
       configuration  
       log reader agent  
       replication  
distributors
       TCP/IP configuration  
distributors, Notification Services  
DLLs (dynamic link libraries)
       Net-Libraries   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
DML
       statements, compiling  
DML (Data Manipulation Language)   2nd  
       commands  
       permissions  
document filters, full-text searches  
document fragments , XML and  
domain integrity  
DRI (declarative referential integrity)   2nd   3rd   4th  
drive types   2nd  
DROP FUNCTION statement  
DROP PROCEDURE statement  
DROP statement
       T-SQL
               linked servers and  
DROP TABLE command  
DROP VIEW command  
DROP_EXISTING
       VLDB  
DROP_INDEX command  
dropping columns, tables   2nd   3rd  
dropping constraints  
dropping indexes   2nd  
dropping linked servers   2nd  
dropping tables
       Enterprise Manager   2nd  
dropping views   2nd  
DSS (Decision Support System)  
DTC (Distributed Transaction Coordinator)  
       MTS and  
       replication and  
DTC (Distributed Transaction Coordinator), Enterprise Manager  
DTS
       architecture   2nd   3rd   4th   5th   6th   7th   8th  
       concepts   2nd   3rd   4th   5th   6th   7th   8th  
       data pump   2nd  
       metadata  
       overview   2nd   3rd   4th   5th   6th   7th  
       package execution utilities   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       tools  
       uses   2nd   3rd   4th   5th  
DTS (Data Transformation Services
       replication and  
DTS (Data Transformation Services)   2nd   3rd   4th   5th   6th   7th   8th  
       Enterprise Manager   2nd  
DTS (Data Transformation Services) utilities   2nd   3rd  
DTS Connectivity  
DTS Designer   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th  
       data-driven queries   2nd  
       Query Designer and  
       transformations  
DTS Import/Export Wizard  
DTS Package Workflow  
DTS Query Designer  
DTS Run GUI utility  
DTS Tasks  
DTS Transformations  
DTS utilities   2nd   3rd  
DTS Wizard   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
DTSRun   2nd  
dtsrun utility   2nd  
dtswiz utility  
dumb terminals  
DUMP command  
Durability, ACID property  
DYNAMIC cursors   2nd  
dynamic SQL
       stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th