Microsoft® SQL Server® 2012 Bible

1354

Index

data compression, 1097–1108

ALTER, 1105–1106

backup, 1099

compression, 1098

B-tree, 1100

clustered indexes, 1098

count(*), 1099

CREATE, 1105–1106

data types, 1099

data warehouses, 1102

queries, 1106–1107

database snapshots, 1099

delete, 1103

dictionary, 1102, 1103

DMVs, 1107

enabling, 1105–1106

Enterprise Edition, 1097, 1098

estimating, 1104–1105

FILESTREAM, 1099

hardware, 1099

heaps, 1098, 1103

indexed views, 1098

inserts, 1103

levels, 1099

memory, 1099, 1102

metadata, 1100

nonclustered indexes, 1098

objects, 1098–1099

page, 1100–1102, 1103, 1106

partition, 1098

performance, 1098

prefi x, 1100–1102

processor, 1098, 1107

pros and cons, 1098–1099

query processing, 1102

restore, 1099

rows, 1098, 1099–1100, 1106

sequence, 1102–1103

settings, 1103–1104

SSMS, 1103–1104

Storage Engine, 1097, 1102

strategies, 1106–1108

tables, 1098–1099

T-SQL, 1106

updates, 1103

Data Compression Wizard, 1104,

1105

Data Conversion, SSIS Data Flow,

1181

data cubes. See cubes

data defi nition language (DDL), 24,

145–146. See also SQL DDL

layer

batches, 391

DML, 1045

query recompiles, 1045

schema locks, 1069

Service Broker, 649

SQL Profi ler, 922

stored procedures, 432–434

triggers, 881, 894–895, 901–906

creating and altering,

901–902

developing, 904–906

enabling and disabling, 904

ENCRYPTION, 903

EventData(), 904–905

EXECUTE AS, 903

managing, 901–904

object_id(), 904

preventing database object

changes, 906

removing, 904

scope, 902–903

security, 903–904

sys.server_triggers, 904

sys.triggers, 904

transaction rollback, 906

views, 276

Data Encryption Standard (DES), 857

Data Flow

Path Editor, 1176

SSIS, 1156

destinations, 1178–1179

sources, 1177–1178

transformations, 1179–1182

SSIS Designer, 1159, 1161

components, 1175–1183

Data Manipulation Language (DML),

97

AFTER, 882

CDC, 954

DDL, 1045

DTC, 381

INSTEAD OF, 883

local distributed queries, 378

OpenDatasource(), 378

query recompiles, 1045

Service Broker, 658

transactions, 1049–1050

triggers, 881

CDC, 961

T-SQL, 389

data mining, 4, 9

SSAS, 1281–1297

algorithms, 1289–1296

association rules, 1294–1295

Business Intelligence

Development Studio,

1283

cache, 1286

Classifi cation Matrix, 1287

clustering, 1291–1292

cross validation, 1288

cubes, 1296–1297

decision trees, 1290–1291

lift charts, 1286–1287

linear regression algorithm,

1291

model evaluation, 1286–1289

Naïve Bayes algorithm, 1294

neural networks, 1293

process of, 1282–1283

scatter plots, 1286–1287

sequence clustering, 1292–

1293

SOAP, 1288

time series, 1296

troubleshooting, 1288

XMLA, 1288

SSIS Control Flow, 1171

Data Mining Designer, 1285–1286

Data Mining Extensions (DMX),

1289

Data Mining Query, 1181

Data Mining Wizard, 1283–1284

Data Profi le Viewer, 1171

Data Quality Services (DQS), 16

Installation Center, 42

instance, 22

SSIS

Connection Managers, 1168

Data Flow, 1181

Data Reader, WMI, 1174

Data Source Designer, 1227

data source view

cubes, 1211

metadata, 1203

PK, 1201–1202

Query Designer, 1201

SSAS, 1211, 1228–1231

SSIS, 1158

data stores, 17

cache, 21

master, 22

planning, 21–24

reference, 22

types and relationships, 21

Data Transformation Services (DTS),

3, 4

SSIS, 1156, 1174

data types, 173–177

character, 174

conversion functions, 207–210

data compression, 1099

bindex July 23, 2012 2:44 PM V1

bindex.indd 1354bindex.indd 1354 7/31/2012 10:39:56 AM7/31/2012 10:39:56 AM

http://www.it-ebooks.info