Microsoft SQL Server 2000 Unleashed (2nd Edition)

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

Object Browser, Query Analyzer   2nd   3rd   4th   5th   6th  

object files

       naming   2nd   3rd   4th  

object instance management, MTS  

object permissions  

       Enterprise Manager and   2nd  

       managing  

       T-SQL   2nd  

Object Search tool, Query Analyzer  

object type indicators, naming standards and   2nd   3rd   4th   5th   6th  

ObjectContext, MTS components   2nd   3rd  

objects

       development environment   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

        names

               passing as parameters   2nd   3rd  

        open , configuration  

       performance objects   2nd   3rd   4th  

       permissions

                owners   2nd  

       scripting   2nd   3rd  

       stored procedures

               identifying   2nd   3rd   4th  

       temporary

               temdb database  

obsolete configuration options   2nd  

ODBC

       applications  

       connection troubleshooting   2nd   3rd  

       datasources

               configuration  

       installation   2nd   3rd   4th   5th  

ODBC drivers

       distributed queries  

ODBCcmpt utility  

odbcping utility   2nd   3rd  

ODS (Open Data Services)

       extended stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  

offsite storage  

OLAP   2nd   3rd   4th   5th  

       business-area focused   2nd   3rd   4th   5th   6th  

       cubes

               creating   2nd  

       database creation

               calculated members   2nd   3rd  

               cube building   2nd   3rd  

               cube processing   2nd  

               datasources   2nd  

               dimensions   2nd   3rd   4th   5th   6th   7th   8th   9th  

               measures   2nd   3rd   4th   5th  

               storage design   2nd   3rd   4th   5th  

       databases

               creating   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   31st  

       OLTP comparison   2nd  

       requirements example   2nd   3rd   4th  

OLAP (On Line Analytical Processing)   2nd   3rd  

OLAP cubes  

OLAP Server   2nd   3rd  

OLE DB  

       consumers  

       distributed queries  

OLTP

       OLAP comparison   2nd  

       remote copies

               central publisher scenario  

OLTP (online transaction processing)  

OLTP (Online Transaction Processing)  

OLTP (Online Transaction Processing) systems  

on-demand disk management   2nd   3rd  

open objects, configuration  

opening cursors   2nd  

OPENXML   2nd   3rd   4th   5th   6th  

operating system

       client requirements  

       requirements  

operating systems

       naming standards   2nd   3rd   4th   5th   6th  

Operator Properties dialog box  

operators

       Agent   2nd   3rd  

       alerts

               Agent   2nd  

       CUBE   2nd   3rd   4th  

       ROLLUP   2nd  

optimistic locking   2nd   3rd   4th   5th   6th   7th  

optimization

       database maintenance   2nd  

options

       databases   2nd  

       incorrect settings  

       information retrieval   2nd  

       setting

               Enterprise Manager  

               T-SQL   2nd  

OR clauses

       query optimization and   2nd   3rd  

OR condition, query optimization and   2nd   3rd   4th   5th  

ORDER BY clause

       SELECT statement   2nd  

               TOP keyword  

OSQL utility   2nd   3rd  

OUTBUFFER command (DBCC), performance monitor and   2nd  

OUTER joins  

Outlook 2000   2nd  

OUTPUT keyword  

output parameters

       sp_executesql and   2nd   3rd   4th  

       stored procedures   2nd   3rd  

Категории