Microsoft® SQL Server® 2012 Bible

1366

Index

normalization (cont inued)

database

extensibility, 18, 148

usability, 17, 148

fi rst-generation data, 21

performance, 147

relational database design,

147–148

NOSKIP, 562

NOT, 181

WHERE, 120, 127

not for replication, 813

notifi cation events, 1230

Notifi cation Services, 4

NotOptimized, 1207

NOTRUNCATE, 600, 601

NO_TRUNCATE, 565

nText, 174

NTILE(), 263–265

OVER(), 265

NULL

CSSASE, 183

DEFAULT NEWSSEQUENTIALID(),

814

full outer joins, 224

INSERT, 294

left set difference query, 232

output parameters, 447

variables, 393–394

null, 373

nulls, 186

aggregate functions, 252

ALL, 243

ANSI, 1036

COALESCE(), 186–187

connections, 476

expressions, 185–190

fi ltered indexes, 1035

intersection unions, 235

ISNULL(), 188–189

NULLIF(), 189–190

PK, 1010

testing, 185–186

where, 1035

NULLIF(), 189–190

NullProcessing, 1221

Number, 1243

Numeric, 175

NUMERIC_ROUNDABORT, 520

nVarChar(), 174

nvarchar, 174

O

objects

BLOB, 455

bulk-loaded recovery model,

553

cmdlets, PowerShell, 775

command, 790

connection, 790

constraints, 791

data compression, 1098–1099

ownership, securables, 842

permissions, 844–847

with code, 846–847

security

securables, 844–850

SSMS, 849–850

SQL Profi ler, 922

transactions, 791

Object Explorer, 82, 89–99, 667

CDC, 956

context menu view, 275

Data Compression Wizard, 1104

database snapshots, 640

Extended Events, 942

Filter, 93

Generate and Publish Scripts

Wizard, 808

log shipping, 667

PBM, 92, 538

Query Designer, 96–98

reports, 98–99

server groups, 88

Service Broker, 650

SMOs, 855

SQL Audit, 968, 974

Azure SQL Database, 802

tree structure, 90

triggers, 882

Object Explorer Details, 93

OBJECT_DEFINITION, 435

OBJECT_ID, 435

object_id(), 904

object-oriented design, 145

entity-value pairs pattern, 163

OBJECTPROPERTY(), 885

objects, connections, 790

ODBC

Client Tools, 1262

linking, 368

SNAC, 74, 76, 77

SSIS, 1157

Control Flow, 1172

Odell, Margaret K., 203

OFFSET, 261–262

ORDER BY, 261

T-SQL, 410–412

OLAP. See Online Analytical

Processing

OLE DB

Client Tools, 1262

external data, 374

Import and Export Wizard, 628

indexed access, 385

linking, 368

remote query execution,

384–385

SNAC, 71, 74, 77

SQL Profi ler, 922

SSAS, 1226

SSIS, 1157

Connection Managers, 1164,

1168

Control Flow, 1172

Data Flow, 1177, 1179, 1181

OLTP. See online transaction

processing

ON, 901

on, 231

ON CONVERSATION, 655

ON DELETE CASCADE, 312

1NF. See fi rst normal form

one's complement operator, 181

one-to-many relationship, 152, 153,

155

one-to-one relationship, 153, 156

on_failure, 968

Online Analytical Processing

(OLAP), 4, 8

BI, 1143–1144

MOLAP, 1197

ROLAP, 1197

SSAS, 1228

online clustering, 747

online transaction processing

(OLTP), 21

BI, 1143

CDC, 954

indexes, 1006

max degree of parallelism,

495

Resource Governor, 1139

transaction blocks, 1093

OPENDATASOURCE(), 377

OpenDatasource(), 378–380

OPENQUERY, 462

OpenQuery(), 377, 380–381

openquery(), 117

OPENROWSET(), 377

OpenRowSet(), 381

OPENXML, 341

sp_sml_prepareddocument,

441

operating system

database security, 20

installation, 32–33

SQLOS, 931–932

__$Operation, 961

bindex July 23, 2012 2:44 PM V1

bindex.indd 1366bindex.indd 1366 7/31/2012 10:39:58 AM7/31/2012 10:39:58 AM

http://www.it-ebooks.info