Microsoft® SQL Server® 2012 Bible

1367

Index

Operational Channel, 941

operational database, 21

operators

bitwise, expressions, 179–181

comparison, 121

Extended Events, 940

PowerShell, 773

division, 178

execution plans, 1001–1002

expressions, 178–179

mathematical, 178

modulo, 178

Object Explorer, 92

one's complement, 181

queries, indexes, 1013–1014

SSIS Expression Language,

1186–1187

string concatenation, 178

optimistic locks, 1088

OPTION, 280

OPTION(RECOMPILE), 1045

options. See also advanced

options

confi guration, 469–529

Query Editor, 102

SSMS, 559

SSRS datasets, 1237

option = 4, 929

option = 8, 929

optionality, 153–154

OR

SELECT, 180

WHERE, 120, 127

Oracle publishing, 730

ORDER BY

FROM, 117

aggregate functions, 251

case, 133

collation, 135–136

columns, 132–133

aliases, 134–135

ordinal numbers, 135

CSSASE, 133

expressions, 133–134

FETCH, 261

multiple assignment variables,

398

OFFSET, 261

result sets, 131–137

SELECT, 235

TOP(), 139

views, 279–280

ouput, 117

Out-DataTable, 792, 797

OUTER APPLY, 245–246, 461

OUTER JOIN, 232

outer joins, 1127

backward compatibility, 223

full, 224–226

multiple, 227

set difference queries, 226

outer queries

FROM, 245

correlated subqueries, 244–246

WHERE, 245

out-null, 786

OUTPUT, 351, 445

batches, 320

deleted, 889

INSERT, 318–319

inserted, 889

MERGE, 320

stored procedures, 320

T-SQL, 320

output parameters

NULL, 447

stored procedures, 445–446,

450

Output window, SSMS, 83

OVER(), 257–258

DENSE_RANK(), 263

NTILE(), 265

PRECEDING, 267

RANK(), 263

overfl ow errors, 518

Override Values, 1185

over-time load, 27

OverwriteDataSets, 1266

OverwriteDataSources, 1266

P

packages

Extended Events, 938

logging, 1187–1188

Package Deployment Model, 1188–

1190

Package Explorer, 1159

Package Parameter, 1160

Package0, 938

packets, 504

PAD_INDEX, 815

PAGE, 575

page compression, 1100–1102, 1103,

1106

Page Lock, 1066

page split problem, 1010–1011

PAGEIOLATCH_x, 935

PAGELATCH_x, 935

PAGE_VERIFY, 526–527

PagLock, 1086

pain level, 548

PAL. See Performance Analysis for

Logs

palindromes, 556

Parallel Data Warehouse, 36

parallelism, processor, 493–495

param, 779

Parameter, 791

parameters

inline table-valued functions,

459–460

input

READONLY, 443

stored procedures, 439–444

installation, 58–60

output

NULL, 447

stored procedures, 445–446,

450

Project Deployment Model,

1183–1184

SSIS, 1160

SSIS Designer, 1183–1185

SSIS Expression Language, 1186

SSRS, 1248–1250

datasets, 1236

startup, 480–482

values

default, stored procedures,

438–439

stored procedures, 438–439

variables, RAISERROR, 415

XML, 351–352

parent-child, 1208–1209

ParentIsBlank, 1209

ParentIsMissing, 1209

ParentIsSelf, 1209

Parse(), 209–210

Parser, Query Optimizer, 1042

partial recovery model, 549

$partition, 1123

partitions, 1109–1129

cubes, 1215–1216

data compression, 1098

database performance, 20

fi legroups, 1118–1120

functions, 1120–1121

horizontal, 1110

indexes, 1117–1128

key, PK, 1111

removing, 1128

rolling, 1127–1128

schemas, 1121

SSIS Data Flow, 1179

stored procedures, 1116

strategies, 1109–1110

tables, 27, 1117–1128

bindex July 23, 2012 2:44 PM V1

bindex.indd 1367bindex.indd 1367 7/31/2012 10:39:58 AM7/31/2012 10:39:58 AM

http://www.it-ebooks.info