E


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




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net