Microsoft® SQL Server® 2012 Bible

1358

Index

durability. See also atomic,

consistent, isolated, and

durable

recovery, 548, 550

transactions, 1049

transaction logs, 550

dynamic management objects

(DMOs), 403–404

metadata, 409

Dynamic Management Views

(DMVs), 978

Change Tracking, 949

data compression, 1107

execution plans, 1000

installation, 68

Plan Cache, 1043–1044

Resource Governor, 1140

Service Broker, 657

transaction locks queries,

1059–1060

wait states, 932–934

dynamic memory, 484–485

E

-e, 481

editions, 12. See also specific

editions

downgrading between editions,

36

downgrading between versions,

36–39

installation, 34–41

licenses, 40–41

upgrading, 39

Effective Maximum Rate, 1132–1133

EKM. See Extensible Key

Management

ELSE, IF, 401

EMERGENCY, 524

ENABLE TRIGGER, 885

EnableCompression, 1228

Encode-SqlName, 784

EncryptByKey, 858

EncryptByPassPhrase, 855

encryption. See also Transparent

Data Encryption

asymmetric, 853, 858–859

authenticator, 856

certifi cates, 854, 859

data, 853–859

database mirroring, 686

hierarchies, 854–855

passwords, 855

stored procedures, 435–436

symmetric, 853, 856–858,

1278–1279

T-SQL, 855–856

views, 287–288

ENCRYPTION, 903

encryption, 814

END TRY, 137, 392

end-of-line returns, T-SQL, 392

endpoints

Object Explorer Security, 91

TCP, 693

Enforce DTC, 503

English Query, 3–4

enterprise data architecture, 15

Enterprise Edition, 12, 36

backup compression, 669

clustering, 746

data compression, 1097, 1098

peer-to-peer topology, 740

Power View, 1327

entities

foreign keys, 151–152

generalization, 150

lookup, 150

one-to-many relationship, 152

PK, 151, 169

relational database design,

148–149

scalar values, 169

entity integrity, 18

entity-value pairs pattern, 163

EntryPoint, SSIS Control Flow, 1173

EOMonth(), 196

-eq, 773

equal, 923

equi-joins. See inner joins

@@Error, 405

@@error, 413

errors

events, 1230

fatal, 424

InventoryTransaction, 896

overfl ow, 518

severity, RAISERROR, 415

SQL Profi ler, 922

SSIS Data Flow, 1177

error handling, T-SQL, 412–424

legacy, 412–414

RAISERROR, 414–418

TRY...CATCH, 418–424

Error List, 83

Error Logs, 92

ErrorConfiguration, 1222

Error_Line(), 420

Error_Message(), 420

@ErrorMsg, SET, 413

Error_Number(), 420

Error_Procedure(), 420

/ERRORREPORTING, 59

Error_Severity(), 420

Error_State(), 420

ESTIMATEONLY, 589

Estimation, SSAS data mining,

1281

ETL. See Extract-Transform-Load

Evaluation Edition, 36

Power View, 1327

events. See also Extended Events

command, 1230

discovery, 1230

errors, 1230

notifi cation, 1230

queries, 1231

SQL Profi ler

fi lters, 923–924

selecting, 921–923

Event Handler, SSIS Designer, 1159

Event Log, 1188

Event Watcher, 1174

EventData()

DDL triggers, 904–905

XML, 905

Events Selection, SQL Profi ler, 921

Excel

linking, 374–376

SSIS Data Flow, 1177, 1179

SSRS, 1269

EXCEPT, 236

Exclusive, 1087

exclusive locks, 1068

ExecIsTriggerDisabled, 885

EXECUTE, 445

EXECUTE AS, 842

triggers, 886

DDL, 903

EXECUTE AS USER, 845

execute object permission, 845

Execute Package, 1160, 1171

Execute Process, 1171

Execute SQL, 1171–1172

ExecuteReader, 797

execution plans, 995–1003

bookmark lookup query path,

1022–1023

DMVs, 1000

estimated versus actual,

996–997

operators, 1001–1002

Plan Cache, 1043–1044

Query Editor, 104–105, 996

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info