objects
calling from within a schema, 7–8
in CLR integration, cataloging, 286–289
filtering, in Management Studio, 90
granting access to, for logins, 299
Linked Objects, SSAS, 75
logical groupings of (schemas)
definition of, 7–8, 307
example of using for security, 307–310
ownership of, changing, 310
performance affected by, 344
in master database, 7
in model database, 7
Replication Management Objects (RMO), 545
in Service Broker, permissions for, 256–257
SQL Server Management Objects (SMO), 90
synonyms for, 8
ODBC, SQL Native Client used by, 5
OLAP (Online Analytical Processing) engine, SSAS, 182, 185, 202
OLE Automation
configuring, 81
default settings for, 75
OLE DB, SQL Native Client used by, 5
OLTP (online transaction processing), 377–378
Online Analytical Processing (OLAP) engine, SSAS, 182, 185, 202
online index operations, 15, 482
online page and file restoration, support for, 15
online transaction processing (OLTP), 377–378
operating modes of database mirroring, 549–550, 558–560
operating systems supported, 13
operators, in SQL Server Agent
alerts notifying, 117
definition of, 110
failsafe operators, 112–113
notifications for, 111–112
optimization
Address Window Extensions (AWE) for, 358–359
CPU considerations for, 395–401
database file placement, 379
I/O problems affecting, 378–382
memory-friendly applications, 395
memory, tuning, 389–395
partitioning of tables and indexes, 382–389
query compilation, 439, 448–453
tempdb database affecting, 380–382
workload, defining, 377–378
(OSCMD) token, 134
osql program, 330. See also sqlcmd program