Microsoft® SQL Server® 2012 Bible

1369

Index

object cmdlets, 775

PATH, 769

PerfMon, 914–917

$profile, 786

Registry, 782

scripts, 769–799

ADO.NET, 790–792

blocks, 776

creating, 777–781

data types, 779

installation, 61–64

servers, 793–799

SMOs, 785–792

SMOs, 786, 845

SSMS, 769, 782

UNIX, 771

variables, 772

Windows Server 2008/2008R2,

769

powershell_ise, 771

Precedence Constraint Editor, SSIS,

1174–1175

PRECEDING, OVER(), 267

preconfi gured traces, 928–929

Predicates, Extended Events, 940

Predict, 1289

PredictProbability, 1289

prefi x compression, 1100–1102

"prepare to commit," DTC, 381

primary fi legroup

metadata, 788

Azure SQL Database, 814

primary key (PK)

BCNF, 169

cardinality, 152–153

Change Tracking, 949

data source view, 1201–1202

entities, 151, 169

entity integrity, 18

exotic joins, 230

full set difference query, 233

indexes, 1010

layers, 164

merge replication, 732

nulls, 1010

partition key, 1111

physical schema, 24

recursive pattern, 161

relational database design, 151

RI, 311

selectivity, 1011

triggers, 881

2NF, 166–167

primary server, log shipping, 665,

683

principal server, 689

PRINT

@@error, 413

@ErrorMsg, 413

INSTEAD OF, 884

SSMS, 446

priority boost, 492

proactive caching, 1225

procedural fl ow, T-SQL, 399–403

processor

affinity I/O mask, 488–490

affinity mask, 488–490

confi guration, 488–495

data compression, 1098, 1107

installation, 33

licensing, 40–41

lightweight pooling, 492–493

max worker threads, 491–492

multithreads, 491–492

parallelism, 493–495

priority boost, 492

Resource Governor, 1133–1134,

1140

System Monitor, 911

@@ProcID, 405

product, in relational algebra, 213

Product Key validation, 48–49

ProductLevel, 472

ProductVersion, 472

$profile, 786

profi le fi les, 786

Profi ler. See SQL Profi ler

profi ler trace, 1032–1033

Programmability, Object Explorer,

91

Progress Report, SQL Profi ler, 922

Progress/Execution Results tab,

SSIS Designer, 1159

project, in relational algebra, 213

Project Deployment Model

parameters, 1183–1184

SSIS, 1156, 1160, 1167, 1190–1191

Project Parameters Editor, 1184

projected columns, 272

Properties

Maintenance Plan, 607–608

Registered Servers, 86–87

SSIS, 1160–1161

SSMS, 83

provider, 372

Proxies, Object Explorer, 92

pSecurity_Assign, 864, 868

p_SecurityCheck, 870–871

pSecurity_Fetch, 863, 866

public role, 847

publishers, 730, 733–734

pull subscription, 740

push subscription, 738–740

Q

/Q, 58

/QS, 58

qualifi ed columns, 131

queries. See also subqueries; specific

types

ad hoc, 377

CDC, 959–963

Change Tracking, 950–953

data warehouse, data

compression, 1106–1107

database snapshots, 641–643

events, 1231

nested, GROUP BY, 255–256

notifi cations, SQL Profi ler, 922

operators, indexes, 1013–1014

outer

FROM, 245

correlated subqueries,

244–246

WHERE, 245

partitioned tables, 1123

performance, 383–386

processing, 1231

data compression, 1102

recompiles, execution plans,

1044–1045

set-based, 25–26

SSRS datasets, 1236

statements, 390

graphical view, 113–114

logical fl ow, 114–116

physical fl ow, 116–117

Query Designer, 113–114

syntax, 112–113

transaction locks, DMVs, 1059–

1060

variables, 397

query(), 355

Query Analyzer, 845

batches, 390

Query Designer

batch-separators, 390

data source view, 1201

debugging, 113

Object Explorer, 96–98

query statement, 113–114

sort, 132

Q (theta) joins, 231

views, 274–275

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info