Microsoft® SQL Server® 2012 Bible

1384

Index

WHILE

BEGIN/END, 401

BREAK, 402

CONTINUE, 402

T-SQL, 82, 401–402

While, PowerShell control fl ow

command, 774

wildcards

LIKE, 125–126

SQL Profi ler, 923

Win32_PingStatus, 30$11

windows

auto-hiding, 85

dockable, 84, 85

fl oating, 83–84

SSMS, 83–85

tabbed, 84

Visual Studio, 83

windowing functions, data,

257–258

partition, 258

Windows authentication, 496,

845–846

delegation, Kerberos, 838

installation, 55

row-level security, 872–874

SQL authentication, 837–838

Windows Azure SQL Database, 75

Windows Domain Controller, 835

Windows Explorer, 640

Windows Integrated Mode. See

Windows authentication

Windows Management

Instrumentation (WMI),

777

Data Reader, SSIS Control Flow,

1174

Event Watcher, SSIS Control

Flow, 1174

Installation Center, 44

SSIS Connection Managers, 1169

Windows Server 2008/2008R2

clustering confi guration,

748–762

installation, 33

PowerShell, 769

Windows Server Failover Clustering

(WSFC), 747

clustering confi guration, 750

database mirroring, 687

WITH, 239

WITH CHECK OPTION, 283, 284–285

WHERE, 285, 851

WITH ENCRYPTION, 287–288

WITH FILE, 575

WITH GRANT OPTION, CSSASCADE,

847

WITH LOG, RAISERROR, 417

WITH RECOVERY, 682–683

WITH RESULT SETS, 448–449

WITH ROLLBACK AFTER, 590

WITH SCHEMA BINDING, 287, 1036

WITH STANDBY, 682–683

WITH TIES, TOP(), 140–141

WITH VIEW METADATA, 288

WithDependencies, 794

WITHOUT LOGIN, CREATE USER, 845

witness server, 689

WMI. See Windows Management

Instrumentation

Word, SSRS, 1269

Workgroup Edition, 35

Workload Governor, 1131

workload groups

default, 1136

internal, 1136

Resource Governor, 1136–1137

write confl icts, transactions, 1085

Write-Ahead Logging (WAL), 1089

WRITELOG/LOGBUFFER, 935

WRITETEXT, 553

WSFC. See Windows Server Failover

Clustering

X

-x, 482

Xact_Abort, 1052

xact_abort, 382

Xact_State(), 420

transactions, 1051

XEvent, 783

XLock, 1086

XML

FROM, 117

API, 341

asynchronous messaging, 648

CLR, 347

columns, 350–351

data, 339–365

data types, 78, 340–352

methods, 353–355

stored procedures, 441–442

EventData(), 905

execution plans, 996

fi le sizes, 425

hierarchies, 336–337

multiple assignment variables,

399

package logging, 1188

parameters, 351–352

return values, 351–352

schemas, 341, 346–350

SHOWPLAN, 999

SSIS

Control Flow, 1174

Data Flow, 1178

SSMS, 347

T-SQL for XML clause, 340

typed versus untyped, 345–346

UTF-16, 340

variables, 350–351

XML for Analysis (XMLA), 1225

SSAS data mining, 1288

XOR, 180–181

XPath, 353

xp_fixeddrives, 600

XQuery, 4, 341, 363–365

PowerShell module cmdlets, 784

XSD. See Schema Defi nition

Language

Y

YEAR(), 1187

Yukon, 4

bindex July 23, 2012 2:44 PM V1

bindex.indd 1384bindex.indd 1384 7/31/2012 10:40:00 AM7/31/2012 10:40:00 AM

http://www.it-ebooks.info