eager writes
flushing data pages to disk, 451
storage engine, 450
eBook, electronic version of this book, xxiv
ELEMENTS keyword, XML RAW and, 86
encryption, 471–475
certificates, 471–472
hardware trends, 406
keys types, 472
overview of, 471
SSL configuration, 473–475
endpoints, TCP/IP, 414
Enterprise Manager, 347
error handling, 218–231
@@ERROR function, 218
@@TRANCOUNT function, 224
exercise using a stored procedure for implementing try/catch blocks, 228–231
localized user-defined messages, 226
overview of, 218
techniques, 218
try/catch blocks, 221–224
user-defined messages, 225
writing error messages to Event Log, 227
XACT_ABORT, 219–221
XACT_STATE ( ), 224
error messages
creating localized user-defined, 226
creating user-defined, 225
creating, modifying, deleting, 225
storing, 225
writing to event logs, 227
error probability, data validation and, 209
estimated query cost, 285
evaluation editions, of software, xxvii
Event Logs, 227
Event Viewer, 227
events
selected events for capture, 376
SQL Server Profiler, 372
Exam 70–442
case scenarios in, xxiii
hardware requirements, xix
labs, xxiv
practice test, xxv
Preparation Guide, xix
software requirements, xx
EXCEPT operators, in SELECT statements, 57
exclusive locks (X-locks), 236, 260, 265
ExecuteAndSend method, 362
execution context, as component of query engine, 458
execution order, query performance, 286–289
execution plan
correlated subqueries, 295
for SARG filtered query, 290
graphical execution plan for query optimization, 289
query performance and, 70
execution time
cursors, 122
query performance, 286
query performance metrics, 294
exist method, XQuery, 83
EXISTS operator, correlated subqueries and, 292
EXPLICIT mode, FOR XML clause, 86
extents, storage engine, 447
EXTERNAL_ACCESS assemblies, 428