Microsoft® SQL Server® 2012 Bible

1357

Index

Delayed Name Resolution, 1042

DELETE, 111, 291, 310–313, 389

FROM, 310–311, 890

ANSI, 311

CTEs, 335

returning data, 319

RI, 311–312

SELECT, 292

transactions, 1049–1050

triggers, 879

multiple-rows, 889–891

UNDO, 310

UPDATE(), 887

WHERE, 310–311

delete, 97, 874

data compression, 1103

nested triggers, 522

delete object permission, 844

deleted

logical tables, 888–889

OUTPUT, 889

triggers, multiple-rows,

890

views, 905

de-militarized network zone (DMZ),

838

DENSE_RANK(), 262–263

OVER(), 263

DENY, 845

deny, 844

DepartmentID, 797

Dependency Network, 1294, 1295

deprecation

announcement, 75

SNAC, 71

AWE, 487

SNAC OLE DB, 75, 77

SQL Profi ler, 921

SSIS, 1158

depth-fi rst approach, to hierarchy

indexes, 334

Derived Column, SSIS Data Flow,

1181

derived tables, 242

APPLY, 245–246

DES. See Data Encryption Standard

DESCRIPTION, 561

Developer Edition, 35, 36

Power View, 1327

Diagram pane, Query Designer, 96

dialogs, Service Broker, 651–655

dictionary compression, 1102, 1103

DIFFERENCE(), 206–207

difference, in relational algebra,

214

difference unions, 236

Differential, 560

differential recovery model, 549,

550–551

digital databases benefi ts, 144

dimensions

attributes, 1204–1205

clean-up, 1207

cubes, 1212–1213

data warehouses, 1151–1153

discretization, 1210

parent-child, 1208–1209

referenced, 1213

regular, 1213

Solution Explorer, 1205

SSAS, 1204–1210, 1212–1213

SSIS Data Flow, 1178

types, 1208

Direct Input, SSIS Control Flow,

1172

directories

PowerShell, 784

SQLSERVER:DAC, 782–783

dirty reads, 1073–1074

DISABLE TRIGGER, 885

disappearing rows, 285

disaster recovery

database mirroring, 686

planning

database availability, 20

SNAC, 75–76

SSRS, 1277–1280

disconnected objects, 790, 791

discovery events, 1230

discretization, dimensions, 1210

DiscretizationBucketCount,

1210

DiscretizationMethod, 1210

DISK, BACKUP, 560

Disk Space Requirements,

installation, 53

Disk Usage Summary, MDW, 986

DisplayFolder, 1207

DISTINCT

GROUP BY, 138

SELECT, 137–138

distinct, 1036

distinctrow, 138

Distributed Partition Views, 4, 1110

distributed queries, 367–386

collation, 385

external data, 367–377

local, 377–378

optimization, 384–385

pass-through, 380–381

SSMS, 377

T-SQL, 378

views, 377

Distributed Replay, 1095

distributed transactions,

381–383

database mirroring, 687

Distributed Transaction Coordinator

(DTC), 7, 382

clustered instances, 756–757

Component Services, 383

confi guration, 762–764

data replication, 728

Object Explorer, 92

distribution agent, 731, 740

distribution database, 730

distributors, 733–735

divide, in relational algebra, 214

division operator, 178

DML. See Data Manipulation

Language

DMOs. See dynamic management

objects

DMVs. See Dynamic Management

Views

DMX. See Data Mining Extensions

DMZ. See de-militarized network

zone

Do Until, 774

Do While, 774

dockable, windows, 84, 85

domain integrity, 18

layer, 164

lookup pattern

foreign keys, 160

relational database design

patterns, 160–161

Double Hop, 1271

DQS. See Data Quality Services

DRI. See declared referential

integrity

driving tables, 223

DROP, 276

SQL Profi ler, 922

stored procedures, 434

triggers, 881

drop, 954

DROP INDEX, bulk-loaded recovery

model, 553

DROP ROLE, 848

DTC. See Distributed Transaction

Coordinator

DTS. See Data Transformation

Services

DTSWIZARD.exe, 628

bindex July 23, 2012 2:44 PM V1

bindex.indd 1357bindex.indd 1357 7/31/2012 10:39:57 AM7/31/2012 10:39:57 AM

http://www.it-ebooks.info