W

W3C (World Wide Web Consortium), 81

WAL (Write-Ahead Logging), 448

WANs (wide area networks), 3

Web services

HTTP Web services, 22–24

XML Web services, 22

Web Services Description Language (WSDL)

creating endpoints and, 21

proxy code generation with, 23

WHERE clauses

compared with check constraints, 200

computed columns and, 317

function in SELECT statements, 456

non-repeatable reads and, 235

phantom reads and, 235

repeatable read isolation and, 240

searchable arguments, 74

SELECT statements, 455

serializable isolation level and, 242

subqueries and, 50

WHILE loops, as alternative to cursors, 117, 133

wide area networks (WANs), 3

Windows OSs

software requirements for Exam 70–442, xx

Visual Studio service packs for Windows Vista, xxi

Windows Event Viewer. See Event Viewer

WITH (HOLDLOCK), locking hints, 260

WITH (NOLOCK), locking hints, 260

WITH (NOWAIT), locking hints, 261

WITH (READ UNCOMMITTED / READ COMMITTED / REPEATABLEREAD / SERIALIZABLE), locking hints, 260

WITH (READPAST), locking hints, 260

WITH (UPDLOCK), locking hints, 261, 265

WITH (XLOCK), locking hints, 260, 265

World Wide Web Consortium (W3C), 81

Write permissions, AMO, 156

Write-Ahead Logging (WAL), 448

write ordering (write dependency), storage engine, 444

write performance, vs. read performance in indexes, 313–316

WSDL (Web Services Description Language)

creating endpoints and, 21

proxy code generation with, 23