O


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



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net