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