E

email systems

Reporting Services Configuration Manager for, 339

security, 532

emergency mode repairs, 208–209

EMPTYFILE option, 316

Enable Package Configurations option, 387

enabling

logins, 581

Replication Monitor alerts, 500

Encrypt All with Password option, 379

Encrypt All with User Key option, 379

Encrypt Sensitive with Password option, 379

Encrypt Sensitive with User Key option, 379

encryption, 570–574, 570

asymmetric, 571–572

hierarchy, 572–573

replication, 491

strategy, 573–574

symmetric, 570–571

encryption keys, 570–572

Reporting Services Configuration Manager for, 339

SSRS, 348

Enforce Password Expiration option, 576

Enforce Password Policy option, 576

entity integrity, 435

equality predicates, missing indexes with, 79

error log files

for deadlocks, 143–146

instance performance, 27–28, 28

error messages

memory-related, 43

tempdb-related, 47

ERRORLOG.x file (SQL Server error log), 28

errors and warnings classes, 239–240

Escalation lock event class, 133, 241

ESTIMATEONLY option

DBCC CHECKALLOC, 298

DBCC CHECKDB, 301

DBCC CHECKFILEGROUP, 305

DBCC CHECKTABLE, 307

ETL (extraction, transformation, and load) platform

master data approach to conflicts, 434

tools, 403

event alerts, 246–250, 246, 248–250

conditions, 250–253, 251–252

WMI, 253–262, 254, 258

event classes

errors and warnings, 239–240

locks, 240–241

SQL Server Profiler, 133, 142–143, 143

stored procedures, 241

T-SQL, 242

events

notifications, 274–280, 275

trace, 256–257, 278–279

Events Selection tab, 148, 148

exact numeric data types, 440

Exceeding the specified latency warning, 500

Exceeding the specified synchronization time warning, 500

Excel destination, 378

EXCEPT operator, 419–422, 421–422

Exception event class, 240

exclusive locks, 129

EXCLUSIVE_TRANSACTION_WOR KSPACE entity, 127

EXECUTE AS statement, 585–586

Execute DTS2000 Package task, 374

Execute Package task, 374

Execute Package Utility dialog box, 370–371, 371

Execute Process task, 374

execution order of DML triggers, 264

Execution Plan tab, 85

Execution Warnings event class, 240

EXPAND VIEW query hint, 91

expiration, password, 576

Expired Subscription Clean Up job, 504

EXPIREDATE option, 192

explicit constraints, 434–439, 434, 436–437

Export Column transforms, 376

EXTENT resource, locks for, 127

Extent Scan Fragmentation statistic, 312–313

Extent Switches statistic, 312

Extents Scanned statistic, 312

external fragmentation, 312

extraction, transformation, and load (ETL) platform

master data approach to conflicts, 434

tools, 403