D

-d switch, using with Sqlcmd, 38–39

DAC (Dedicated Administrative Connection), relationship to Sqlcmd, 38

damage page tracking, support for, 60

data adapters

using with DTP, 189–190

using with packages, 198

data, extracting by event type with Profiler, 45

Data Flow Designer, using with Integration Services, 207–209

data loading, support for, 13–14

data mining, algorithms for, 237–238

data partitioning

implementing, 10–12

support for, 42–43

Data Source View Designer, using, 228

Data Source View Wizard, starting, 227

data sources

choosing for Import/Export Wizard, 203–204

creating with Report Wizard, 176

and data source views in Business Intelligence Development Studio, 226–228

using in Business Intelligence Development Studio, 226–228

data transformation projects, opening for Integration Services, 206

Data Transformation projects, using in Business Intelligence Development Studio, 36

data types, support for, 7–8

data warehousing, storing dimensional data in, 217–218

DATABASE ATTACH and DETACH commands, using with full-text catalogs, 64

database availability enhancements

Database Snapshots, 56–58

dedicated administrator connection, 60

Early Restore Access, 58–59

fine grained online repairs, 60

Hot-Plug memory, 61

improved dynamic configuration, 61

online index operations, 59–60

overview of, 55–56

transaction isolation levels, 61–62

database connections, defining with Report Wizard, 176

database data files, enhancements in, 9

database failure, protection against, 50–55

Database Mirroring

versus clustering, 55

combining Database Snapshots with, 57

dynamics of, 53–54

features of, 52

implementing, 52–53

initializing, 54

support for, 8

database objects

creating in schemas, 16

creating with CLR, 69

managing ownership of, 16

managing with SQL Server Management Studio, 27

manipulating with Object Explorer, 29

Database Page Checksums, features of, 63–64

database schemas. See schemas

Database Snapshots

combining with Database Mirroring, 57

overview of, 56–58

support for, 8

Database Tuning Advisor, features of, 42–44

DataID field of ADF, description of, 118

DataNotifications class, description of, 119

datasets, defining for reports, 167

DataTable object, creating for ADO.NET paging, 102

DataTriggerValue field of ADF, description of, 118

date-to-string conversion, example of, 76

DbCommand object, using with ADO.NET Provider Factory, 104

DDL triggers

features of, 9

T-SQL support for, 93–94

dedicated administrator connection, support for, 60

default constructor UDT method, description of, 81

DELETE statements, producing DML output from, 94

DeliveryChannel tag in config.xml file, significance of, 113

Design Surface in Report Designer, features of, 167

Design the Query dialog, displaying in Report Wizard, 177

Design the Table window, displaying in Report Wizard, 179

development and management tools

Business Intelligence Development Studio, 33–38

SQL Computer Manager, 24–25

SQL Server Management Studio, 25–33

Sqlcmd utility, 38–40

Dialog protocol, using with SQL Server Service Broker, 130–131

dialog security, implementing for SQL Server Service Broker, 139–140

dialogs

declaring in SQL Server Service Broker application, 136

in SQL Server Management Studio, 27

using with SQL Server Service Broker, 128–129

digital signing, using with Integration Services packages, 197–198

Dimensions pane, displaying in OLAP Report Designer, 169–170

dimensions, relationship to OLAP, 217

Discover method, using with XML for Analysis Services, 158

discover requests, using with XMLA, 235

disk and I/O errors, detecting, 63–64

distinct count members, aggregating in MDX, 236

Distributor element of ADF, description of, 120

distributor, role in Notification Services, 108–109

DLLs

generating for .NET stored procedures, 74

importing for UDAGGs, 88

using with UDTs, 84

DML output, T-SQL support for, 94

DMO (Distributed Management Objects), relationship to SMO, 46

drill-down option, using with Reporting Services, 184–185

DROP ASSEMBLY command, example of, 69

DROP TABLE statements, using DDL triggers with, 93

DROP* T-SQL DDL statements, descriptions of, 133

DSO (Decision Support Objects), relationship to AMO, 237

DT (Decision Trees) algorithm, relationship to data mining, 238

dtexec package execution utility, features of, 214

dtexecui package execution utility, features of, 214

DTP (Data Transformation Pipeline), role in Integration Services, 189–190

DTR (Data Transformation Runtime), role in Integration Services, 189, 191–192

DTS containers. See containers

DTS data adapters. See data adapters

DTS (Data Transformation Services), overview of, 188. See also Integration Services; packages

DTS event handling. See event handling

DTS log providers. See log providers

DTS packages. See packages

DTS tools, overview of, 202–203

DTS transforms. See transformations

DTS variables, Integration Services support for, 194–196

dtswizard command, effect of, 203

dtutil tool, using with Integration services, 213

dynamic configuration, improvements to, 61

Dynamic Help window

in Business Intelligence Development Studio, 37

in SQL Server Management Studio, 32