R

RAM

relationship to NUMA, 6

support for, 5

Range partitioning, using, 11

RDL (Report Design Layout) format, using with Reporting Services, 164, 170

read applications, increasing data availability for, 61

RECEIVE statements

using WAITFOR commands with, 95

using with SQL Server Service Broker application, 138

RECEIVE T-SQL DML statement, description of, 133

Rectangle control, using with Report Designer, 166

recursive members, using with CTEs, 91

Registered Servers window in SQL Server Management Studio, features of, 27–28

registered XML schemas, retrieving, 146–147

replace operations, performing with Modify() method, 148

report authoring

development stages of, 173–174

overview of, 173

report controls, setting in Report Designer, 165–166

report definitions, storing in Reporting Services, 164

Report Designer

deploying reporting solutions from, 182

Design Surface in, 167

Fields window in, 168

Output window in, 168

Properties window in, 167

role in Reporting Services, 164

Solution Explorer in, 167

starting, 165, 174

Toolbox window in, 165–166

report formats, availability in Reporting Services, 164

report layouts, creating with Design Surface, 167

Report Manager

ActiveViews in, 173

features of, 172

role in Reporting Services, 164–165

Report Project template, using in Business Intelligence Development Studio, 36

Report Project Wizard, using in Business Intelligence Development Studio, 36–37

Report Server

features of, 170–171

and report delivery, 171

role in Reporting Services, 164

Report Wizard, creating reports with, 174–181

reporting servers, creating, 57

Reporting Services

architecture of, 162–165

OLAP Report Designer component of, 168–170

Report Designer component of, 165–168

Report Manager component of, 172

Report Server component of, 170–171

significance of, 162

Reporting Services applications, developing, 173–174

reporting solutions

building and deploying, 173–174

deploying from Report Designer, 182

designing, 173

reports

creating with Reporting Services, 174–181

deploying in Reporting Services, 181–183

displaying row detail lines in, 184

making available to end users, 174

previewing in Report Designer, 167

running in Reporting Services, 183–185

selecting design of, 180

testing with Reporting Services, 183–184

ReportServer database, storing report definitions in, 164

reservation system, creating SQL Server Service Broker objects for, 134–135

ResRequestDialog variable, using with SQL Server Service Broker application, 136

ResRequestQueue

adding message to, 135–136

creating for SQL Server Service Broker application, 135

ResRequestService target, role in SQL Server Service Broker application, 136

ResResponseQueue, creating for SQL Server Service Broker application, 135

ResResponseService sender, role in SQL Server Service Broker application, 136

RESTORE action, significance of, 59

restore and backup

of concurrent databases and logs, 64

and Database Page Checksums, 63–64

enhancements in Analysis Services, 225

media reliability enhancements in, 62–63

partial restore, 62

RESTORE VERIFYONLY command, effect of, 63

Results window, displaying in SQL Server Management Studio, 26, 30

RMO (Replication Management Objects), features of, 47

ROLAP (relational OLAP), overview of, 218

row detail lines, displaying in Reporting Services reports, 184

rows

inserting in MyContacts table, 85

removing from OrderSum table, 94

rules, defining for Notification Services applications, 110

run-time properties, setting for packages, 193–194