Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

RANK function

RANK ranking function 2nd

ranking functions 2nd

    DENSE RANK

         T-SQL enhancements 2nd

    NTILE

         T-SQL enhancements 2nd 3rd

    RANK

         T-SQL enhancements 2nd

    ROW NUMBER

         T-SQL enhancements

     T-SQL enhancements 2nd 3rd

READ COMMITTED isolation level

read committed transactions

     snapshot isolation

READ UNCOMMITTED isolation level

read-committed isolation level

real-time log shipping [See database mirroring]

Rebuild Index task

receiving

     messages 2nd

recompilation

RECOMPILE hint

recovering

     deleted tables with database snapshots 2nd 3rd

recursion

     infinite loops

recursive CTE

recursive CTEs

redundancy

     mirrored backup media

         performing backups 2nd 3rd

reference dimensions

Registered Servers window

relational engine

relational operators

    APPLY

         T-SQL enhancements 2nd

    PIVOT

         T-SQL enhancements 2nd

    UNPIVOT

         T-SQL enhancements 2nd

relational reporting

     in OLAP

reliability

     ATTACH REBUILD LOG clause

     backup and restore operations verification 2nd

     Emergency mode, invoking 2nd

     I/O transaction validation 2nd

     mirrored backup media

         performing backups 2nd 3rd

     online restorations

     page restorations

     piecemeal restorations

remote service bingings (Service Broker)

Reorganize Index task

repairing

     fragmented indexes

REPEATABLE READ isolation level

replication 2nd 3rd

     enhancements to 2nd 3rd

     merge replication

     of Oracle data

     of schema changes

     peer-to-peer transactional

Replication Monitor

Report Builder

Reporting Services 2nd 3rd

reserved address space

reserved page allocator

Resource database 2nd 3rd

     accessing

resource database

resource monitor 2nd

resource waiter list

restorations [See restores]

     early restore access 2nd

     performing on Service Broker applications

restores

     online

     page

     piecemeal

     verifying 2nd

restricting access to metadata 2nd 3rd 4th

RMO (Replication Management Objects) 2nd

ROLAP (Relational OLAP)

role-based security

     Analysis Services 2005 2nd

routes 2nd 3rd

routing

     tasks to scheduler

Row Count transformation

ROW NUMBER function

ROW NUMBER ranking function

ROW OVERFLOW DATA AUs

Row Sampling transformation

row versioning 2nd 3rd 4th 5th 6th 7th 8th

     dependent features

     enabling

rows

     ranking 2nd

runnable list