O

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]

object permissions 2nd 3rd 4th 5th 6th
OBJECT_ID() function
OBJECT_NAME() function
objects
     naming conventions 2nd
     object definitions 2nd
     system objects 2nd
     user objects 2nd
ODBC Structured Query Language (OSQL)
OFFLINE option (databases)
OLE-DB 2nd
one-tier systems 2nd
one-to-many relationships 2nd 3rd 4th
one-to-one relationships 2nd 3rd
Open Objects option (server properties)
OPEN statement
OPENQUERY function
OPENROWSET function 2nd 3rd
OPENXML keyword (SELECT statement) 2nd 3rd
operating systems
     service properties 2nd
operators 2nd 3rd
     arithmetic operators
     BETWEEN
     bitwise operators
     comparison operators 2nd
     CUBE 2nd
     definition of
     EXISTS
     IN
     LIKE 2nd
     logical operators 2nd
     ROLLUP 2nd
     unary operators
OPTIMISTIC cursors
optimization 2nd 3rd 4th 5th
     concurrency 2nd 3rd
     Current Activity view 2nd 3rd 4th 5th 6th
     DBCC (Database Console Command) 2nd 3rd
         maintenance options 2nd
         miscellaneous options 2nd
         trace flags 2nd
         validation options 2nd
     Event Viewer 2nd
     exam prep questions 2nd 3rd 4th
     indexes 2nd
         clustered 2nd
         covering 2nd
         dropping 2nd
         full-text 2nd
         Index Tuning Wizard 2nd
         indexed views 2nd
         nonclustered 2nd 3rd
         rebuilding 2nd 3rd
         strategies 2nd
         what not to index 2nd 3rd
         what to index 2nd
     locks 2nd 3rd
         contention 2nd
         controlling lock behavior 2nd 3rd
         exclusive locks
         granularity
         shared locks
         transaction isolation levels 2nd
     partitioned views 2nd
         indexing 2nd
     Query Optimizer 2nd 3rd 4th
         execution plan caching and sharing 2nd
         hints 2nd 3rd 4th 5th 6th 7th 8th
         reading execution plans 2nd 3rd 4th 5th
     SQL Profiler 2nd 3rd
         diagnosing locking with 2nd 3rd
         templates
         traces 2nd 3rd 4th 5th 6th 7th
     statistical functions 2nd 3rd
     stored procedures 2nd 3rd 4th
         recompilation 2nd
         web applications and 2nd
     transactions 2nd 3rd
         atomicity
         beginning 2nd
         consistency
         durability
         isolation
         isolation levels 2nd
         rolling back 2nd
ORDER BY clause (SELECT statement) 2nd
ordering data 2nd
OSQL (ODBC Structured Query Language)
OUTER JOIN statement 2nd 3rd
outer joins 2nd 3rd
owners (databases)
     changing
ownership
     broken ownership chains, troubleshooting 2nd 3rd