Index R


[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]

RAI   [See RROR command]2nd   [See RROR command]3rd   [See RROR command]4th   [See RROR command]5th   [See RROR command]6th   [See RROR command]7th   [See RROR command]8th   [See RROR command]9th   [See RROR command]10th   [See RROR command]
RAID (Redundant Array of Inexpensive Disks)   2nd   3rd   4th   5th   6th   7th  
RAISERROR command
       triggers and  
RANGE ROWS, index histogram  
range searches
       key locking and   2nd   3rd   4th   5th  
ranges, index searches  
RAW mode, XML   2nd   3rd  
RDBMS (relational database management system)
       client/server architecture   2nd  
read aheads   2nd   3rd  
Read Committed mode, isolation levels   2nd  
Read Uncommitted mode, isolation levels and   2nd  
readpipe utility   2nd   3rd  
real-time cubes, AS  
rebuildm utility   2nd   3rd   4th  
RECONFIGURE WITH OVERRIDE statement  
recovery
       replication and   2nd   3rd  
       transactions   2nd   3rd   4th   5th   6th   7th   8th   9th  
recovery interval option  
recovery interval, configuration   2nd   3rd  
recovery mode
       setting   2nd  
recovery models  
Recovery models  
recovery options  
recursive stored procedures   2nd   3rd   4th   5th   6th   7th  
recursive triggers   2nd   3rd  
redundant data, denormalization and   2nd   3rd  
referenced objects, stored procedures   2nd   3rd   4th  
referential integrity  
       Cascading Referential Integrity   2nd   3rd  
       constraints
               FOREIGN KEY   2nd   3rd   4th   5th  
       triggers and   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
refreshing full-text indexes   2nd   3rd  
registering servers, Enterprise Manager   2nd  
registration
       instances, Notification Services   2nd   3rd  
regrebld utility   2nd   3rd  
regular cubes, AS  
Reinitialize Subscriptions Having a Data Validation Failures agent  
relational database management system (RDBMS)
       client/server architecture   2nd  
relational databases   2nd   3rd   4th   5th   6th   7th   8th   9th  
       limitations  
relationships, English Query
       adjective phrasing  
        name /ID phrasing  
       prepositional phrasing  
       subset phrasing  
       trait phrasing  
       verb phrasing  
relationships, English Query applications   2nd   3rd   4th   5th  
reliability, enterprise computing  
remote datasources, linked servers   2nd   3rd   4th  
Remote Delete operator, Query Analyzer  
Remote Insert operator, Query Analyzer  
remote installation  
remote locations
       master lists
               central publisher scenario  
remote proc trans, configuration   2nd  
Remote Query operator, Query Analyzer  
Remote Scan operator, Query Analyzer  
remote servers   2nd  
       connecting to  
       Enterprise Manager   2nd  
       overview   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       setup   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
remote stored procedures   2nd  
Remote Update operator, Query Analyzer  
renaming tables   2nd  
repairing problems   2nd  
Repeatable Read mode, isolation levels   2nd  
replaying trace data   2nd   3rd  
replicatin catalog tables  
replication   2nd  
       articles  
               filtering   2nd   3rd   4th   5th   6th  
       autonomy of data   2nd   3rd  
        backups and   2nd   3rd  
       central publisher scenario   2nd   3rd   4th  
       central publisher with remote distribution scenario   2nd   3rd  
       central subscriber scenario  
       distribution database and   2nd   3rd  
       distribution methods   2nd   3rd  
       distribution server  
       Enterprise Manager  
                publications  
               subscriptions   2nd  
       failure troubleshooting   2nd   3rd   4th  
       heterogeneous   2nd   3rd  
       immediate transactional consistency  
       immediate update  
       Internet subscribers  
       latency of data   2nd   3rd  
       latent transactional consistency  
       log shipping as alternative   2nd   3rd   4th   5th   6th  
       merge   2nd   3rd  
                preparations   2nd   3rd   4th  
       merge replication   2nd  
       monitoring  
               Enterprise Manager   2nd   3rd  
               SQL statements and   2nd   3rd   4th   5th  
       Msrepl_commands  
       Msrepl_transactions  
       multiple subscribers scenario   2nd  
       overview   2nd   3rd  
       performance issues   2nd  
       Performance Monitor and   2nd  
       publication server  
       publications  
       publishing subscriber scenario   2nd  
       recovery and   2nd   3rd  
       scripting   2nd   3rd   4th  
       setup   2nd  
               publications, creating   2nd   3rd   4th   5th  
               publishing, enabling   2nd   3rd   4th  
               subscriptions, creating   2nd   3rd   4th   5th   6th  
       snapshot   2nd   3rd  
               updating subscribers and  
       snapshot replication  
       stored procedures   2nd  
       subscribers   2nd   3rd  
               updating   2nd   3rd  
       subscription server   2nd  
       timing of data   2nd   3rd  
       transactional   2nd   3rd   4th  
       transactional replication   2nd   3rd  
               distribution agent  
        user requirements, design and   2nd   3rd   4th   5th  
replication agent
       Reinitialize Subscriptions Having a Data Validation Failures  
replication agents  
       Agent History Clean Up  
       distribution agent   2nd  
       Distribution Agent  
       Distribution Clean Up  
       Expired Subscription Clean Up  
       log reader agent   2nd   3rd  
       merge agent   2nd  
       Replication Agents Checkup  
       snapshot agent   2nd   3rd   4th   5th  
       Snapshot Agent  
       snapshot agent
               processing   2nd   3rd   4th  
Replication Agents Checkup agent  
Replication Agents object, Performance Monitor  
Replication Alerts folder, Replication Monitor  
Replication Dist. object, Performance Monitor  
Replication Distribution Agent  
Replication Log Reader Agent  
Replication Logreader object, Performance Monitor  
Replication Merge Agent  
Replication Merge object, Performance Monitor  
Replication Monitor
       snapshot agent  
Replication Queue Reader Agent  
Replication Snapshot Agent  
Replication Snapshot, Performance Monitor  
replication utilities   2nd   3rd  
report generation
       database maintenance  
Report view, Performance Monitor  
reports
       Index Tuning Wizard   2nd  
Repository   2nd  
responses, alerts   2nd  
restoration
       VLDB  
restore
       databases
               partial   2nd  
       T-SQL   2nd   3rd  
RESTORE DATABASE command  
Restore Database dialog box  
RESTORE LOG command  
restores  
       bulk_logged recovery   2nd  
       databases   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
               T-SQL   2nd   3rd   4th   5th  
       Enterprise Manager   2nd   3rd   4th  
       filegroups   2nd   3rd  
       files   2nd   3rd  
       full recovery  
       plan development   2nd   3rd  
       point-in-time   2nd  
       recovery mode   2nd  
       simple recovery   2nd  
       system databases   2nd   3rd   4th   5th  
       to different databases  
       transaction logs
               T-SQL   2nd   3rd  
       typical scenario   2nd   3rd   4th  
restoring
       enhancements   2nd  
results  
resultsets
       stored procedures
               INSERT statement  
retail pricing chart  
RETURN statement   2nd  
       scalar functions  
returning messages, T-SQL   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
reusing query plans, query optimization and   2nd   3rd   4th   5th   6th   7th   8th   9th  
REVOKE command  
rewriting stored procedures as functions   2nd   3rd   4th  
RI (referential integrity)  
RI constraints
       cascading   2nd  
ROLAP (Relational OLAP)  
roles
       application roles   2nd  
               permissions  
       database roles
               Enterprise Manager and   2nd  
               T-SQL and   2nd  
       Enterprise Manager   2nd  
       fixed-database roles   2nd   3rd  
               managing   2nd  
       fixed-server
               managing   2nd  
       fixed-server roles   2nd  
       MTS   2nd  
                components   2nd  
       security   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       user-defined
               permissions  
       user-defined roles   2nd  
ROLLBACK statement  
rollback tran statement  
ROLLUP operator   2nd  
root element, XML documents  
Row Count Spool icon, Query Analyzer  
row offset table   2nd   3rd   4th  
row-level locking   2nd   3rd  
ROWCOUNT_BIG( ) function  
rows
       adding   2nd   3rd   4th  
        cursors
               modifying   2nd  
       data pages   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th  
       deleting  
               from heap   2nd   3rd   4th   5th  
               from index   2nd   3rd   4th   5th  
               reclaiming space  
       duplicate
               removing  
       filtering
               WHERE clause  
       indexes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
               estimating   2nd   3rd   4th  
       leaf rows, nonclustered indexes   2nd   3rd   4th   5th   6th   7th  
       nonleaf rows, nonclustered indexes   2nd   3rd  
       security, views and   2nd   3rd   4th  
       size limits  
       tables
               deleting   2nd  
               entity integrity  
       text in row data   2nd  
       updating  
               forward pointers   2nd   3rd  
               in place updates   2nd  
               not in place updates   2nd   3rd  
rowset functions   2nd   3rd   4th   5th  
rowset providers  
rowversion  
RPCs (Remote Procedure Calls)  
rules   2nd  
       binding
               precedence   2nd   3rd  
       CREATE RULE command   2nd   3rd  
       creating   2nd   3rd  
       limitations   2nd  
       managing   2nd   3rd  
        names   2nd  
       restrictions  
rules of normalization, logical database design and  



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net