MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

RAID (redundant arrays of inexpensive disks) technology, 165–166

RAID-0, 166, 166

RAID 0+1, 168–169, 169

RAID-1, 166–167, 167

RAID-5, 167–168, 167

RAID-10 (1+0), 168, 168

RAISERROR statement, 247

Raw File destination, 378

RCA (root cause analysis), 164

reactive troubleshooting approach, 2

Read committed isolation, 124–125

Read committed snapshot isolation, 125, 138, 512

READ_ONLY option, 138

read operations, shared locks for, 129

Read uncommitted isolation, 124–125

Readahead Pages/sec counter, 232

READCOMMITTED hint, 140

READCOMMITTEDLOCK hint, 140

READPAST hint, 140

READUNCOMMITTED hint, 140

real data type, 441

real-time requirement, 222

rebinds in query plans, 84

REBUILD clause, 107–108

rebuilding indexes, 107–108, 309

Recommendations tab, 75, 75

recompilations

queries, 89–90

troubleshooting, 39–40, 41

Recompile event class, 90, 241

RECOMPILE option, 89

RECOMPILE query hint, 91

Recompile/SQL counter, 40

Recordset destination, 378

recovery, 164

databases

backups. See backups

login configuration, 204–205

lost data, 205

models, 180–182

salvaging data, 206–209

scripts, 205–206, 206

exam essentials, 209

failure causes, 164

fault tolerance. See fault tolerance

review questions, 210–219

SQL Server, 177–179

steps, 177–179

summary, 209

RECOVERY option, 197

redundancy checks, 424–425

redundant arrays of inexpensive disks. See RAID (redundant arrays of inexpensive disks) technology

referential integrity, 434

regulatory requirements

in data assessment, 401

in security, 526–527

Reinitialize Subscriptions Having Data

Validation Failures job, 504

Released lock event class, 133

relevant data, 402

Rely on Server Storage for Encryption option, 379

remote objects in query plans, 84

remote tables, 458

REORGANIZE clause, 106–107

reorganizing indexes, 106–107

REPAIR_ALLOW_DATA_LOSS option

DBCC CHECKALLOC, 298

DBCC CHECKDB, 208, 302

REPAIR_FAST option, 302

REPAIR_REBUILD option, 303–304

Repeatable Read isolation, 124, 126

REPEATABLEREAD hint, 140

replication, 174, 174, 427, 455–456

administering, 490–491

agents, 175, 478–480

monitoring, 500

profiles, 508–511

alerts, 494–498, 495–497

components, 174–175

conflicts. See conflicts

DMVs, 35–36

exam essentials, 514

factors, 480

integrity, 492–494

linked servers. See linked servers

merge, 175, 478

conflicts in, 506–508, 507–508

multiple master approach, 432–433, 432

performance baselines, 513

performance tuning, 511–513

push subscriptions, 486–490, 486–490

Replication Monitor. See Replication Monitor

review questions, 515–521

security issues, 491–492

in server-to-client environments, 481

in server-to-server environments, 480–481

summary, 514

terminology, 474–475, 475

transactional, 481–485, 482–485

types, 175–177, 177, 476–480

Replication Agents Checkup job, 505

Replication Monitor, 498–499, 498–499

agent profiles, 510

maintenance plans, 504–505

threshold warnings, 499–500

verifying replication, 500–504, 501–503

Replication monitoring refresher for distribution job, 505

replmerge.exe (Merge Agent), 175, 479–480

Report Manager, 337–338, 337

Reporting Services. See SQL Server Reporting Services (SSRS)

Reporting Services Configuration Manager, 338–339, 340

Reporting Services subsystem, 560

reports

Database Tuning Advisor, 76, 76

Summary Report pane, 25–27, 25–26, 48–50, 48–50

Reports tab, 76, 76

Reports tool, 324

reportserver database

backing up, 348

capacity planning, 350

moving, 349, 349

reportservertempdb database

backing up, 348

capacity planning, 350

representation criteria for data, 402

reputation criteria for data, 402

Resolver page, 432, 432, 508, 508

resource consumption baselines, 513

Resource Locking Statistics by Object reports, 49

Response page, 497, 497

restarting failed packages, 380–382

RESTORE statement, 192, 195

RESTORE DATABASE statement

file and filegroup restores, 199–200

full restores, 196–197

partial restores, 197–198

snapshots, 201–204, 203

RESTORE LOG statement, 200–201

restoring

databases, 194–204, 203

pages, 207–208

Result Set of Policy (RSoP) tool, 589

RETAINDAYS option, 192

REVERT statement, 585

review meetings for data assessment, 401

REVOKE statement, 579

rewinds in query plans, 84

rewriting queries, 88

RID resource, locks for, 128

right outer joins, 410–412, 410–412

risk evaluation in data assessment, 401

RMO, 492

@rmtpassword parameter, 466

@rmtsrvname parameter, 465

@rmtuser parameter, 466

roles

adding users to, 540–542, 540–541

database, 584–585

server, 580–581

root cause analysis (RCA), 164

routes, Service Broker, 276

Row Count transforms, 377

row-level locks, disabling, 139

Row Sampling transforms, 377

ROWLOCK hint, 140

rows in query plans, 83–84

Rows Read counter, 386

Rows Written counter, 386

rowsets with OLE DB providers, 470

Rpc option, 463

Rpc Out option, 463

rs utility, 340

rsconfig utility, 340, 349

rskeymgmt utility, 341

RSoP (Result Set of Policy) tool, 589