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