R

RADIANS function, 318, 585

RAID controllers, 271

RAID systems, 141

RAISERROR function, 585

RAISERROR statements, 88, 328, 390

RAND function, 317–318, 585

RANK function, 585

rate, performance monitoring, 538–539

RAW mode, 469, 515

raw partitions, 148, 155

RDBMS (relational database management system), 3–7

RDO (Remote Data Objects), 12

reactive server analysis, 531

READ_ONLY option, 156

READ_WRITE option, 156

reading and writing data pages, 63–64

read-only database mode, 200

read-only filegroups, 138, 142

read-only options, standby server, 234

READTEXT function, 585

real constants, 293

real data type, 302, 308, 578, 585

RECEIVE function, 585

RECONFIGURE function, 585

records, database, 26

recovery architecture. See disaster recovery

recovery completion state parameter, Management Studio, 200

recovery models, database, 144

recovery state parameter, Management Studio, 199

recovery_option section, 157–158

recursion, trigger, 392

RECURSIVE_TRIGGERS Sql_option, ALTER DATABASE statements, 157

redundancy, 211–212, 256–257, 261

(ref_column [,…n]) argument, 169

ref_table argument, 169

reference scope boundaries, 348

Reference types feature, CLS, 335

reference variables, .NET automatic memory management, 341

referential integrity, 34, 169, 359–360

referral networks, 107–108

Registry functions, 538

Registry keys, 126

relational constraints, 360–361

relational database engines, 11, 51–52, 63, 68–69

relational database management system (RDBMS), 3–7

relational model, Date, 357

Relational OLAP (ROLAP) database, 142

relations, 26

relative identifiers (RIDs), 105

reliability, SQL Server Backup Options page, 196

remote cluster storage, 270

Remote Data Objects (RDO), 12

remote monitoring, 556

remote stored procedures, 401,402

REMOTE_PROC_TRANSACTIONS

statements, 503

REMOVE FILE argument, 154

REMOVE FILEGROUP argument, 154

REPLACE function, 314, 585

replacement parameters, 390–391

REPLICATE function, 315, 586

replication, 211–232

establishing requirements, 214

implementation of, 221–231

configuring publisher, 226–228

creating publication, 228–231

overview, 221

subscribing to publication, 221–226

Not For Replication argument, 168

options, 218–220

overview, 17, 211–214

requirements for establishing, 214

services, 215–216

settings, database, 198

topology design, 231–232

types, 216–218

Replication Agents SQL Server object, 548

Replication Dist SQL Server object, 548

Replication Logreader SQL Server object, 548

Replication Merge SQL Server object, 548

Replication Snapshot SQL Server object, 548

reporting, logical, 469

reports, database, 149

resolution, deferred name, 391

Resource Database, 23

Resource Monitor, Cluster Service, 272

response time, performance monitoring, 539

restore

database, 201–202

page-level, 138

RESTORE FILELISTONLY function, 586

RESTORE function, 586

RESTORE HEADERONLY function, 586

Restore Job, SQL Server Agent, 243

RESTORE LABELONLY function, 586

RESTORE MASTER OR SERVICE MASTER KEY function, 586

restore process, log shipping, 236

RESTORE REWINDONLY function, 586

RESTORE VERIFYONLY function, 586

restricted data, 102–103

RESTRICTED_USER option, 156

result sets, 412, 449–451, 482, 503–505

results, T-SQL expression, 294–295

RETURN function, 327, 586

reuse benefits, stored procedure, 399

REVERSE function, 315, 586

REVOKE function, 133–134, 586

RIDs (relative identifiers), 105

RIGHT function, 586

right outer joins, 463, 473–474

rights, 99–100

RIGHT(string, integer) function, 315

robotic library systems, 183

ROLAP (Relational OLAP) database, 142

role switching, 245, 250–251

role-based security, 349–350

roll forward transactions, 60

ROLLBACK TRANSACTION function, 501, 586

ROLLBACK WORK function, 501, 586

rollbacks, 45, 60, 154, 498

ROLLUP arguments, 464–465

root node, 511–512

rotation schemes, 204–206

ROUND function, 318, 586

row counts, 389–390

row locks, 491

ROWCOUNT_BIG function, 587

rowguid values, 217

ROWGUIDCOL property, 168, 375, 457

row-level versioning, 140

ROWNUMBER function, 587

rowpattern, OpenXML, 520

rows, in tables, 26

ROWS_PER_BATCH argument, 433

rowset functions, 437

rowversion data type synonym, 307

RTRIM function, 315, 587

rule enforcers, triggers as, 380

Rules of Normalization, 446

rules of precedence, 452

runtime. See CLR (Common Language Runtime)