Service Broker

Database Mirroring

Extended MAPI Profile

Microsoft Exchange Server

In the Simple recovery model, all transactions are logged.

In the Bulk-Logged recovery model, all transactions are logged.

In the Full recovery model, most transactions are minimally logged.

In the Simple recovery model, most transactions are minimally logged.

2K

8K

16K

4K

-c

-E

-u

-p

3604

2512

302

310

max memory

physical memory

logical memory

network memory

DBINFO

DES

IDES

DBTABLE

dbcc checkdb

dbcc checkverify

dbcc checkstorage

dbcc checkalloc

auto identity

identity in nonunique index

unique auto_identity index

async log service

with header

with headerofdump

with dumpstatus

with listonly

ASEENGINE

ANYENGINE

LASTENGINE

LASTONLINE

230

450

255

100

sybmgmtdb

sybsystemprocs

model

master

is_chained

tran_chained

chained

tranchained

0

3

2

1

Schema synonym

Public synonym

Private synonym

Database synonym

CREATE SYNONYM

CREATE ANY SYNONYM

CREATE PUBLIC SYNONYM

CREATE OTHER SYNONYM

Select

Insert

Update

Delete

Table

View

Procedure

Package

Another Synonym

Sequence

Alias for a schema object

Provide security by hiding the name of the object

Provide security by hiding the schema owner of the object

Reduce complexity in SQLs by creating short synonyms names for objects with long names

By granting privilege to synonym, granting privilege to the underlying object can be avoided