Microsoft® SQL Server® 2012 Bible

1362

Index

INSERT (cont inued)

UPDATE(), 887

views, 283

insert, 97, 873

CDC, 954

nested triggers, 522

inserts

data compression, 1103

object permission, 844

INSERT... EXECUTE, 449–450

INSERT/DEFAULT VALUES, 292

inserted

logical tables, 888–889

OUTPUT, 889

triggers, multiple-rows, 890

INSERT/EXEC, 292, 298–300

INSERT/SELECT, 292, 296–298

INSERT/VALUES, 292

rows, 293–296

installation, 31–69

AD, 55, 68

AlwaysOn Availability Groups, 32

BPA, 67–68

command-line utilities,

58–60

Disk Space Requirements, 53

DMVs, 68

editions, 34–41

Extended Events, 68

fi rewalls, 34

hardware requirements, 32–33

Installation Center, 42–58

memory, 33, 65–66

model database, 68

.NET Framework, 33

operating system, 32–33

parameters, 58–60

patches, 68

post-installation tasks, 65–68

PowerShell scripts, 61–64

processor, 33

server, 32–34

service accounts, 54

software requirements, 32–33

SSAS, 32

SSMS, 68

SSRS, 32, 1261–1265

steps of, 42–68

storage, 33

TCP/IP, 66–67

Windows authentication, 55

Windows Server 2008/2008R2, 33

Installation Center, 42–58

/INSTALLSHAREDDIR, 59

/INSTALLSQLDATADIR, 59

instances

backups, 793

clustered, 756–762

DTC, 756–757

confi guration, 51–52

database mirroring, 688

default versus named, 58

DQS, 22

fi rewalls, 34

SSAS, BISM, 1324–1325

SSMS, 58

/INSTANCEDIR, 59

/INSTANCENAME, 59, 580

INSTEAD OF, 283, 313

BEFORE, 883

AFTER, 895

DML, 883

INSERT, 884

Inventory, 899

PRINT, 884

rows, 884

tables, 883

triggers, 880, 883–884

Int, 175

int(), 178

Integration Services. See SQL Server

Integration Services

integrity. See specific types

Intent Exclusive Lock (IX), 1068

intent locks, 1068–1069

Intent Shared Lock (IS), 1068

IntentExclusive, 1087

IntentShared, 1087

Interactive Sorting, 1244

internal resource pools, 1132–1133

internal tables, 949–950

internal workload groups, 1136

intersection

in relational algebra, 214, 215–

216, 224

unions, 235–236

INVENTORY, 900

Inventory, 896–900

INSTEAD OF, 899

JOIN, 897

Inventory_Aggregate, 900

InventoryTable, 896

InventoryTransaction, 896–900

errors, 896

Invoke-PolicyEvaluation, 784

Invoke-SQLCmd, 792, 797

Invoke-Sqlcmd, 784

InvTrans_Aggregate, 898

IS. See Intent Shared Lock

IS, 186

IS NOT, 186

IsAggregatble, 1210

is_auto_update_stats_async_

on, 590

IsDescendantOf(), 328–330

ISNULL, 1151

ISNULL(), 1187

nulls, 188–189

isolation. See also atomic,

consistent, isolated, and

durable

deadlocks, 1066

snapshots, 1082–1085

transactions, 1047, 1049

ANSI, 1071

levels, 1070–1086

locks, 1066

ISVs. See Independent Software

Vendors

ItemID, 154

item-level permissions,

1273–1274

item-level roles, 1273

itemsets, 1294–1295

iteration, 798

iterative code

indexes, 26

performance, 26

physical schema, 24

T-SQL, 25

IX. See Intent Exclusive Lock

J

Jobs, Object Explorer, 92

Job Activity Monitor, Object

Explorer, 92

JOIN, 217, 226

Inventory, 897

scalar subqueries, 240–241

joins

FROM, 217

cross, 229–230

exotic, 230–231

inner, 216–221

intersection unions, 235

multiple data sources,

220–221

rows, 218–220

multiple-condition, 231

outer, 1127

backward compatibility, 223

full, 224–226

multiple, 227

set difference queries, 226

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info