Microsoft® SQL Server® 2012 Bible

1361

Index

fi lter, 328

IsDescendantOf(), 328–330

methods, 331–334

nodes, 330–331

subtrees, 329–330

ToString(), 327

WHERE, 328

high-availability

cluster ing, 746–747

database availability, 20

SNAC, 75–76

Azure SQL Database, 806

high-performance mode, database

mirroring, 691–692

high-safety mode, database

mirroring, 689, 690

HoldLock, 1086

horizontal multiples, Power View,

1339–1340

horizontal partition, 1110

horizontally positioned views, 286

HOST_NAME(), 191

HTTP

ports, 73

SSIS Connection Managers, 1169

HTTPS, 859

Hydra, 3

hyperthreading, 494

I

/IACCEPTSQLSERVERLICENSETERMS,

59

identity_value, 857, 858

IF, 392, 399

BEGIN/END, 399–400

ELSE, 401

nested, 400–401

statements, 137

T-SQL, 82, 399–401

If, 774

IF EXISTS, 313

IF EXISTS(), 400

IIF, 184

IIS, 838

Image, 177

Report Designer Toolbox, 1242

impersonation, 1228

implicit transactions, 1053

import, PowerShell modules, 782

Import and Export Wizard, 627–630

Import Column, SSIS Data Flow, 1181

IMPORT-MODULE SQLASCMDLETS,

782

IMPORT-MODULE SQLPS, 782

IN

ANY, 244

SOME, 244

subqueries, 241

WHERE, 122–125

inactive transactions, 563

Independent Software Vendors

(ISVs), 386

indexes, 17

access, OLE DB, 385

base, 1034

B-tree, 1006–1007

Change Tracking, 949

clustering, 1007–1008

data compression, 1098

foreign keys, 1033

linked lists, 1008

rows, 1033

scan, 1001

seek query path, 1017–1018,

1019

selecting, 1033

columnstore, 16, 27, 1038

composite, 1010

fi lter by ordered, 1029

comprehensive strategy, 1032–

1034

concurrency, 26

constraints, 1010

data compression, 1098–1099

database performance, 20

DBCC, 594–598

density, DBCC, 597–598

EXTENDED_LOGICAL_CHECKS,

589

fi ll factors, 598

fi lter, 1035–1036

heaps, 1012–1013

hierarchies, 334

iterative code, 26

key queries, 1032–1033

locks, 1069–1070

nonclustered, 1009–1010

data compression, 1098

page split problem, 1010–1011

partitions, 1117–1128

tables, 1128

physical schema, 25

PK, 1010

query operators, 1013–1014

query path, 1014–1032

query recompiles, 1045

scan, 1001, 1013

search, 1008

seek, 1002, 1013

selectivity, 1011–1012

set-based queries, 25

statistics, DBCC, 597

strategies, 1005–1039

unique, 1010

unordered heaps, 1012–1013

views, 27, 1036–1038

data compression, 1098

distinct, 1036

Query Optimizer, 1037

with schema binding, 1036

update, 1038

index create memory, 487–488

Index Properties Storage, SSMS,

1103

IndexAsAccessPath, 385

Indexes, 795

@index_name, 956

Indicator, 1243

Indicators, 1253–1255

indirect checkpoints, 565

Information Architecture Principle,

16–17

INIT, 562

init, 378–379

initiating service, 649

inline table-valued functions

parameters, 459–460

UDFs, 458–462

in-line views, 117

inner joins, 216–221

intersection unions, 235

multiple data sources, 220–221

rows, 218–220

INPUT, 351

input parameters

READONLY, 443

stored procedures, 439–444

INSERT, 111, 291, 292–302, 389

FROM, 890

AFTER, 883

CTEs, 335

DEFAULT, 294–295

default rows, 300

IF EXISTS, 313

INSTEAD OF, 884

local distributed queries, 378

NULL, 294

OUTPUT, 318–319

returning data, 318–319

SELECT, 292

tables, 300–302

triggers, 879, 895

multiple-rows, 889–891

TRY...CATCH, 313

bindex July 23, 2012 2:44 PM V1

bindex.indd 1361bindex.indd 1361 7/31/2012 10:39:57 AM7/31/2012 10:39:57 AM

http://www.it-ebooks.info