Microsoft® SQL Server® 2012 Bible

1383

Index

PowerShell, 772

queries, 397

scope, 393–394

SELECT, 393–395

SET, 394–395

SSIS, 1160

Control Flow, 1172

SSIS Designer, 1185–1186

SSIS Expression Language, 1186

tables, T-SQL, 407–408

T-SQL, 393–399

XML, 350–351

VeriSign, 854, 859

@@VERSION, 471–472

@@Version, 405

versions, 3–4

Change Tracking, 950–951

compatibility, 38

downgrading, 36–39

rows, 1083–1085

transactions, 1048

vertical multiples, Power View,

1339–1340

vertical partition, 1110

views. See also data source view;

Dynamic Management

Views; Power View

aggregate functions, 283

aliases, 272

altering and dropping, 278

columns

aliases, 279

security, 273

compute, 281

compute by, 281

context menu, Object Explorer,

275

data, 271–289

sources, 1228–1231

DDL, 276

deleted, 905

distributed queries, 377

DMVs, 978

encryption, 287–288

WITH ENCRYPTION, 287–288

executing, 276–278

execution plans, 996–1000

graphical, 113–114

horizontally positioned, 286

indexes, 27, 1036–1038

data compression, 1098

distinct, 1036

Query Optimizer, 1037

with schema binding, 1036

in-line, FROM, 117

INSERT, 283

local-partition, 1111–1116

locks down, 284–288

metadata, 288

nested, 281

Object Explorer, 91

ORDER BY, 279–280

partitions, 1110–1116

local, 1111–1116

UNION ALL, 1114

UPDATE, 1115–1116

WHERE, 1114

performance, 283

Power View, 1338

protecting, 286–287

Query Designer, 274–275

query recompiles, 1045

Resource Governor, 1140

restrictions, 280–281

security, 851

SELECT, 271, 274, 275, 287–288

SELECT INTO, 280

SSMS, 274, 278

stored procedures, 434–435

synonyms, 288–289

temporary tables, 280

UDFs, 272

UPDATE, 283

updates, 282–283

indexed, 1038

WHERE, 272, 277

View Designer, 274–275

View Properties, 287

View T-SQL, Maintenance Plan,

607–608

virtual machines, 41

virtual tables. See views

Visibility, Report Designer Text

Box Properties window,

1244

visible layer, 164

Visio, 154

Visual Studio

Report Designer, 1234

windows, 83

W

wait states, 931–936

AD, 936

DMVs, 932–934

Extended Events, 936

MDW, 936

red-fl ag, 935

requests, 932

SQLOS, 931–932

waitfor, 653

WAL. See Write-Ahead Logging

warm standby, log shipping,

663–664, 665, 683

warnings

events, 1230

SQL Profi ler, 922

SSAS, 1208

Watch window, T-SQL, 82

waterfall process, 25

Web Browser, SSMS, 83

Web Edition, 36

Azure SQL Database, 805

Web Service, SSIS Control Flow,

1173

web synchronization, data

replication, 743

WHEN, 183

WHERE

AND, 127

FROM, 113, 117, 120

IN, 122–125

OR, 127

advanced options, 478

ALL, 122–125

ANY, 122–125

WITH CHECK OPTION, 285, 851

correlated subqueries, 244–245

@CurrencyCode, 437

DELETE, 310–311

full outer joins, 226

full set difference query, 233

HierarchyID, 328

joins, 215

lists, 122–125

multiple conditions, 127–128

NOT, 127

OpenQuery(), 380

outer queries, 245

partition views, 1114

ROW_NUMBER, 259–260

rows, 285

scalar subqueries, 240–241

SELECT, 128, 396, 459–460

UDFs, 453

UNION ALL, 234

views, 272, 277

where

between, 1018

nulls, 1035

SQL Audit, 970

WHERE...LIKE, SQL Profi ler,

921

Where-Object, 775, 776

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info