R

RAISERROR statement, 222

ranking functions, queries, 58

RAW mode

exercise generating XML, 92

FOR XML clause, 86

RDOs (Remote Data Objects), 32

Read, AMO permissions, 156

read committed isolation level

exercise acquiring locks using, 256–258

exercise using, 253–256

locking hints, 260

transactions, 236–238

read committed snapshot isolation level, 250–252

read locks, concurrency problems, 235

read performance, vs. write performance in indexes, 313–316

read uncommitted isolation level, 238–239

READ_ONLY, cursor concurrency options, 120, 134

read-ahead

parallel query plans contrasted to, 454

SQL Server 2005 database engine, 453–454

ReadDefinition permissions, AMO, 156

READPAST, locking hints, 260

recordset objects, 11

recursive queries, 118–119

refresh strategy, caching and, 108

relational databases, querying. See queries

Remote Data Objects (RDOs), 32

repeatable read isolation level, 240–241

replication. See also RMO (Replication Management Objects)

defined, 149

peer-to-peer, 359

results sets, from queries, 57

RIGHT joins, 50

RMO (Replication Management Objects), 149–153

assemblies, 150

class library, 150

namespace, 150

overview of, 149

publisher and distributor, specifying, 151

roles, SSAS security, 156

ROW_NUMBER function, 293

rows

covered indexes compared with non-covered, 307

optimizing row width in data storage, 332–333

performance benefits of covered indexes, 306

SARG filter for reducing rows returned by query, 290

RTRIM function, 468

rules

applying data validation rules to tables, 214

for implementing data integrity, 195

for implementing foreign key constraints, 196