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