MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

WAIT lock request state, 132

wait types, 120–121

warm standby solutions, 165

Warnings and Agents tab, 498–500, 498

WBEM (web-based enterprise management), 253

Web Service task, 374

WHERE clause

full outer joins, 414–415

left outer joins, 409

right outer joins, 411

Windows authentication, 575, 577

Windows Management Instrumentation (WMI), 253

Windows Server Update Services Server (WSUS), 566

Windows troubleshooting tools, 6–9, 7–8, 12–18, 13–15, 17–18

wiring up SSIS packages, 366

WITH ENCRYPTION clause, 494

WITH GRANT option, 579

Wizard Actions page, 489

WMI (Windows Management Instrumentation), 253

WMI Data Reader task, 374

WMI event alerts, 253–262, 254, 258

WMI Event Watcher task, 374

WMI Query Language (WQL), 254

Working Set counter, 23

Worktables Created/sec counter, 233

worms, 530–532

WQL (WMI Query Language), 254

Write a Report to a Text File option, 332

WSUS (Windows Server Update Services Server), 566