R

Index

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

RDL (report definition language)
     converting to RDCL
RDLC extension files
     converting RDL to
     DataSets block
Read method
real data type
records affected value, capturing
Reflector
Refresh method 2nd
RefreshReport method
registering servers with Server Explorer
reinstalling
     DACW (DataAdapter Configuration Wizard)
     deprecated data components
relational databases [See also ADO.NET, class names; DBMSs (database management systems), client considerations.]
    administrative functions
         Auto Close option
         importing/exporting data
         .MDF database files, attaching
     backing up
     BLOBs, avoiding
     check constraints
    columns
         binding rules to
         definition of
         strongly typed data columns
     concurrency
     constraints
     creating in code
     creating with Server Explorer
     data types
         ANSI 2nd
         barbinary
         bigint
         binary
         bit
         char 2nd
         cursor
         datetime
         decimal
         doubleprecision
         exact numerics
         float
         image
         imprecise numbers
         int
         money
         nchar
         ntext
         numeric
         nvarchar
         real
         smalldata
         smallint
         smallmoney
         sql_variant
         sysname
         table
         text
         timestamp
         tinyint
         UDTs (user-defined types)
         Unicode 2nd
         uniqueidentifier
         varchar 2nd
         xml
    database connections [See connections, client/server connection management.]
    Database Diagrams
         creating
         definition of
     definition of
     design principles
    example databases
         aliases
         attaching
         chapter-specific configuration issues
         installing
     identifiers
     indexes
     maximum size of
     multiple databases
     normalization
         definition of
         first normal form
         second normal form
         third normal form
     object names
     overview of
     parent/child relationships
    primary keys
         changing
         defining
         GUIDs (globally unique identifiers)
         multi-column primary keys
         primary key/foreign key relationships
    rows
         definition of
         dropping all rows
         inserting 2nd
         limiting number of rows returned
         ordering rows returned
         row-overflow storage
         updating
     rules
     system databases
    tables [See tables, aliases.]
     transaction logs
     transactions 2nd
    updating [See updates.]
     user databases
         creating
         managing
relationships, managing in Data Source designer
releasing connection pool connections
remote debugging
RemoveFilter method
RemoveSort method
Render method 2nd
rendering server reports
RenderingBegin event
RenderingComplete event
RenderStream method
replication
     in SQL Server Express Edition
     in SQLEv (SQL Server Everywhere Edition)
     SqlCommand objects
report definition language [See RDL (report definition language).]
Report Designer (BIDS) 2nd
Report Items toolbox
report parameters
     creating
     definition of
     sample application
Report Viewer
     configuring
     events
     methods
     overview of
     properties
ReportEmbeddedResource property (LocalReport class)
ReportError event
ReportExport event
Reporting Services
     architecture
     BIDS Report Designer 2nd
     features
     overview of
     RDL (report definition language)
     sample summary report
ReportPath parameter (server reports)
reports
     adding to projects
     BIDS Report Designer 2nd
     click-through reports
     Data Sources
     expressions
     formatting
     laying out
     LocalReport class
         events
         methods
         properties
    Matrix report
         building
         custom report cache table
         data considerations
         grouping data
         initial SELECT Query
         layout
         testing
     overview of
     Query parameters
     RDL (report definition language)
         converting to RDCL
     RDLC extension files
         converting RDL to
         DataSets block
     Report Items toolbox
     report parameters
         creating
         definition of
         sample application
     report queries
    Report Viewer
         configuring
         events
         methods
         overview of
         properties
    Reporting Services
         architecture
         features
         overview of
     sample summary report
    server reports
         accessing on Reporting Services
         methods and functions
         parameters 2nd
         rendering
         ServerReport class
     SubReport item
     testing
ReportServer database
ReportServerCredentials parameter (server reports)
ReportServerUrl parameter (server reports)
reserved words, avoiding in object names
Reset method
ResetBindings method
ResetCommandTimeout method 2nd
ResetCurrentItem method
ResetDbType method
ResetItem method
ResetSqlType method
resetting server report parameters
resources, managing
restoring data
     backup and deployment issues
     importance of
     security
resultsets
     CLR stored procedures
     fetching
     MARS (Multiple Active Resultsets)
ResumeBinding method
retrieving data
     Identity values
RETURN values
     populating
     stored procedures
ReturnProviderSpecificTypes property (SqlDataAdapter class)
reusable components, building
Roeder, Lutz
roles (SQL Server)
RowFilter property (DataView class)
rows
     definition of
     dropping all rows
     inserting
         Identity values
         NULL and DEFAULT values
         SELECT INTO syntax
     limiting number of rows returned
     ordering rows returned
     row-overflow storage
     SqlDataReader rows, fetching
     updating
         BLOBs
         concurrency
         decimal and floating point numbers
         parameter-based updates
         strings
         strongly typed data columns
         UPDATE SET syntax
RowState property (DataRow objects)
RowStateFilter property (DataView class)
RowUpdated event
RowUpdating event
     executing Update logic with
     trapping
rules
    business rules
         extended properties
         overview of
     T-SQL Rules
         binding to columns
         creating
Run Selection feature
running report queries