O

object catalog views, 348

object IDs, in storage engine, 447

Object Linking and Embedding Database. See OLE DB (Object Linking and Embedding Database)

object-oriented programming, 133. See also Transact-SQL

objects

AMO fundamental objects, 154

Auto Stats trace event, 461

core objects in AMO, 154

data sources connection objects and, 6

in SQL Sever object model, 145

ODBC (Open Database Connectivity)

data access methods, 8–9

MARS enabled for use with SNAC ODBC provider, 171

OLAP (Online Analytical Processing)

AMO classes for OLAP processing, 155

cubes and dimensions and, 154

OLE DB (Object Linking and Embedding Database)

accessing multiple data sources, 51

data access with, 10

MARS enabled for use with SNAC ODBC provider, 171

Online Analytical Processing. See OLAP (Online Analytical Processing)

Open Database Connectivity. See ODBC (Open Database Connectivity)

OPENDATASOURCE function, 352

OPTIMISTIC, concurrency options, 134

optimizing data storage. See data storage optimization

optimizing indexes. See index performance

optimizing queries. See query performance

OPTION clause, query hints and, 71

ORDER BY clauses

query execution order and, 288

result sets of SELECT statements and, 455

orphaned connections, application performance and, 385

OUTER APPLY operator, in SELECT statements, 56

outer joins, 291

output caching

exercise using OutputCache directive, 109–112

overview of, 99

page-level, 99

user control-level, 100–101

OutputCache directive

attributes, 100

exercise using, 109–112

page-level caching and, 99