Microsoft® SQL Server® 2012 Bible

1371

Index

relational algebra/logical design,

145, 213

relational database design, 143–171

cardinality, 152–153

columns, 145–146

database basics, 143–154

entities, 148–149

foreign keys, 151–152

generalization, 149–150

layers, 164

normalization, 147–148

optionality, 153–154

patterns, 154–164

domain integrity lookup

pattern, 160–161

recursive pattern, 161–162

supertype/subtype pattern,

159–160

phases, 146

PK, 151

rows, 145–146

SSAS, 1227

strategy, 170–171

tables, 145–146

relational OLAP (ROLAP), 1197

Reliability and Performance

Monitor, 1138–1139

remote access, 502–503

remote distributors, 734–755

remote login timeout, 503

remote proc trans, 503

remote query execution, OLE DB,

384–385

remote query timeout, 503

remote stored procedures, 436–437

RemoteSigned, 63

REPAIR_ALLOW_DATA_LOSS, 591,

592

REPAIR_REBUILD, 591

RepeatableRead, 1075–1078

locking hints, 1086

REPLACE, 576

REPLACE(), 200–201, 1187

replication

data, 727–744

agents, 731–732

confi guration, 732–743

merge publ icat ion, 741–743

peer-to-peer, 731, 740–741

servers, 727–729

types, 730–731

web synchronization, 743

merge, 731

Object Explorer, 91

snapshot, 730

transactions, 730

Replication Management Objects

(RMOs), 785

reports

ad hoc, 1234, 1327

authoring environments,

1234–1235

authoring from scratch, 1239–

1240

data sources, 1235–1236

database mirroring, 687

datasets, 1236–1237

grouping, 1251–1252

lists, 1251

matrix, 1245–1247, 1251

MDW, 985–988

Object Explorer, 98–99

Power View, 1327–1346

deploying, 1344–1345

Report Wizard, 1237–1239

sections, 1251

sort, 1251–1252

SSMS, transaction blocks, 1057

SSRS, 1233–1259

deploying, 1265–1271

native mode, 1266–1269

Report Builder, 1255–1258

SharePoint, 1269–1271

SSDT, 1265–1266

tables, 1251

Report Builder, 4, 1235, 1268

reports, 1255–1258

Report Data, Report Designer,

1241–1243

Report Data Source, Power View,

1330–1332

Report Defi nition Language (RDL),

1237

Report Designer

Report Data, 1241–1243

Solution Explorer, 1241

SSDT, 1234, 1262

SSRS, 1234, 1240–1244

layout, 1251–1255

Text Box Properties window,

1243–1244

Toolbox, 1241–1243

Visual Studio, 1234

Report Gallery, 1235, 1258

Report Manager, 1235, 1258, 1268

AD, 1272

datasets, 1268

deploying reports, 1266–1269

item-level permissions,

1273–1274

Report Wizard

reports, 1237–1239

SSRS, 1237–1239

reporting databases. See caching

data stores

Reporting Services. See SQL Server

Reporting Services

ReportServer, 1278

ReportServerTempdb.

ReportServer, 1278

requests, wait states, 932

RequireClientauthentication,

1228

RESEED, 593

Resolve Reference Window, 1183

Resource Governor, 1131–1140

classifier, 1135, 1138

Database Engine, 1140

DMVs, 1140

limitations, 1140

memory, 1133, 1140

Object Explorer, 92

OLTP, 1139

performance, 1138–1139

processor, 1133–1134, 1140

resource pools, 1132–1135

SLA, 27

views, 1140

workload groups, 1136–1137

Resource Monitor, 6

resource pools

default, 1132–1133

internal, 1132–1133

Reliability and Performance

Monitor, 1138–1139

Resource Governor, 1132–1135

RESOURCE_SEMAPHORE, 935

RESTART, 562

restore

data compression, 1099

data replication, 729

point-in-time, 82

SSMS, 570–574

SSRS, 1269, 1279–1280

RESTORE

database snapshots, 638

NORECOVERY, 565

RESTORE DATABASE, 575

database snapshots, 643–644

RESTORE LOG, 575

RESTORE VERIFYONLY, 562

RESTORE WITH NONRECOVERY, 573

RESTORE WITH RECOVERY, 573

RESTORE WITH STANDBY, 573

RESTORE WITH VERIFYONLY, 574

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info