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]

Object Explorer window 2nd

Object Explorer window (SQL Server Management Studio) 2nd

object-scoped permissions

obtaining

     query execution plans as XML text

offline restorations

OLAP

     Analysis Services

     business intelligence

     cubes

     data sparsity

     dimensions

     measures

     relational reporting

     storage modes

OLAP (online analytical processing)

OLE DB Command transformation

OLTP (online transaction processing)

online index operation

online index operations 2nd 3rd

online restoration

OPENROWSET function

OPENXML function

operation modes

     of database mirroring

         asynchronous mode 2nd

         synchronous mode 2nd

operations and configuration tools

     Database Mail 2nd 3rd

         configuring 2nd 3rd 4th

         monitoring 2nd

     SQL Server Configuration Manager 2nd 3rd

     SQLCMD

         command-line switches 2nd 3rd

         commands

         dedicated administrator connection

         environment variables 2nd 3rd 4th

         startup scripts 2nd

         variables 2nd

OPTIMIZE FOR hint

Optimize Schema option (Analysis Services 2005 2nd

optimizing

     queries on xml type columns 2nd 3rd

OUTPUT clause 2nd

Output window (BIDS)

ownership chaining 2nd [See also module execution context]

     limitations of 2nd