Microsoft® SQL Server® 2012 Bible

1373

Index

ScrappedReasonID, 1035

scripts

blocks, PowerShell, 776

Database Designer, 620

database transfer, 620–624

PowerShell, 769–799

ADO.NET, 790–792

creating, 777–781

data types, 779

installation, 61–64

modules, 778

servers, 793–799

SMOs, 785–792

schemas, 620

security, 620

servers, 620

SMOs, 793, 794

SSDT, 620

SSIS Data Flow, 1178, 1179

SSMS, 620–621

Table Designer, 620

T-SQL, 793

Generate and Publish Scripts

Wizard, 808

Script, SSIS Control Flow, 1173

Script Component, SSIS Data Flow,

1182

ScriptDrops, 794

Scripter, 794

ScriptLanguage, 1173

.SDF, 1168

search

indexes, 1008

Object Explorer Details, 93

search argument (SARG), 1031–1032

second normal form (2NF), 166–167

securables, 841–856

object ownership, 842

object security, 844–850

permissions, 843–844

chains, 841–842

security model, 850–851

secure by default, 71

security

auditing, 497–498

C2 audit tracing, 497–498

columns, views, 273

confi guration, 496–498

cross database ownership

chaining, 498–499

database, 20

DDL triggers, 903–904

model, securables, 850–851

objects

securables, 844–850

SSMS, 849–850

Object Explorer, 91

physical, 20

procedure, 861

row-level, 861–875

scripts, 620

Server Agent, 737

server authentication mode,

496–497

SSIS Connection Managers, 1168

SSMS, 370–373, 497

SSRS, 1271–1277

stored procedures, 431

tables, 861

triggers, 886, 892

views, 851

Security Audit, 922

security identifi er (SID), 837

Security table, 862–863

foreign keys, 862

PersonLogin, 874

/SECURITYMODE, 59

sed, 771

SEEK, 1006

Segmentation, SSAS data mining,

1281

SELECT, 111, 389

FROM, 112–113, 117, 242

OR, 180

cast(), 302

columns, 394

column aliases, 279

CTEs, 335

data modifi cation, 292

DISTINCT, 137–138

GetLevel(), 333

inline table-valued functions,

458

IS, 186

ISNULL, 1151

joins, 215, 217

local distributed queries, 378

logical fl ow, 116

multistatement table-valued

functions, 462, 463

object permissions, 845

ORDER BY, 235

output parameters, 445

query fl ow, 137–141

result sets, 296–298

rows, 395

self-joins, 229

SERVERPROPERTY, 472

SOUNDEX(), 205

stored procedures, 450

TOP(), 138–141

transactions, 1049–1050

UDFs, 453

UNION, 302

UNION ALL, 234–235

unions, 234

variables, 393–395

views, 271, 274, 275, 287–288

WHERE, 128, 396, 459–460

select, 97, 873

from, 96

SELECT*, 130

IF EXISTS(), 400

trivial plans, 1045

Select*, 1024

SELECT INTO, 235, 553

views, 280

select object permission, 844

SELECT/INTO, 292, 300–302

selectivity indexes, 1011–1012

Select-Object, 775

select-object, 771, 777

self-joins, 227–229

SEND, 651, 655

Send Mail, 1173

SensitiveOnServer, 1184

Sequence, SSIS container, 1170

Sequence Analysis, 1282

sequence clustering, 1292–1293

Serializable, 1078–1082

locking hints, 1086

Server, 786

Scripter, 794

servers. See also specific types

confi guration, 471–474

connectivity, enabling, 72–74

data replication, 727–729

environment

hardware, 17

system functions, 210–211

groups, Registered Servers,

88–89

installation, 32–34

nodes, Database Engine, 90

PowerShell scripts, 793–799

scripts, 620

SQL Profi ler, 922

SSAS, 1225

witness, 689

Server + CAL licensing, 41

Server Activity History, 986–987

Server Agent, 6

BACKUP, 559–562

clustered instances, 756

security, 737

bindex July 23, 2012 2:44 PM V1

bindex.indd 1373bindex.indd 1373 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM

http://www.it-ebooks.info