Microsoft® SQL Server® 2012 Bible

1353

Index

default language, 508

output parameters, 445

Azure SQL Database, 812

SQL Profi ler, 922

stored procedures, 433

triggers, 881

create

Server Audit Specifi cation,

972

symmetric encryption, 856

Create, Retrieve, Update, and Delete

(CRUD), 432

CREATE ANY DATABASE, 624

CREATE DATABASE, 624

database snapshots, 639

create database, 805

CREATE DATABASE database_name

FOR ATTACH, 615, 627

CREATE INDEX, 1035

bulk-loaded recovery model, 553

CREATE LOGIN, 844

create master key, 854

CREATE PROCEDURE, 437

CREATE QUEUE, 649

poison message, 656

CREATE ROUTE, 648

create server audit, 968

CREATE SERVICE, 649

create table, 813, 903

CREATE USER, 844

WITHOUT LOGIN, 845

CREATE XML SCHEMA, 347

create_login, 902

create_table, 902

Credentials, Object Explorer

Security, 91

CROSS APPLY, 245–246, 460–461

cross database ownership chaining,

498–499

cross joins, 229–230

cross validation, SSAS data mining,

1288

CRUD. See Create, Retrieve, Update,

and Delete

Cryptographic Providers, Object

Explorer Security, 91

cryptography, database security, 20

CSV. See comma-delimited fi les

CTEs. See common table expressions

cubes

actions, 1214–1215

aggregations, 1216–1217

calculations, 1213

data source view, 1211

data storage, 1219

dimensions, 1212–1213

ErrorConfiguration, 1222

KPI, 1214

measures, 1212

NullProcessing, 1221

partitions, 1215–1216

perspectives, 1217–1218

processing, 1219–1220

SSAS, 1204, 1210–1218

data mining, 1296–1297

SSRS, 1245–1247, 1271

UnknownMember, 1221

@CurrencyCode, 445

WHERE, 437

@CurrencyCodeOutput, 446

@CurrencyName, 445

@CurrencyNameOuput, 445

CURRENT ROW, 266

CURRENT_TIMESTAMP, 192

cursors

confi guration, 513–514

iterative code, 25

SQL Profi ler, 921

cursor close on commit, 514

cursor default, 514

cursor threshold, 513

CXPACKET, 935

D

-d, 481

DAC. See Data-Tier Application

dashboards, SSMS, 83

data

access tracing, SNAC, 77

aggregate functions, 249–256

architecture, 15–30

audit trails, data integrity, 19

backup, database availability,

20

Change Tracking, 945–954

collection

customization, MDW,

989–991

MDW, 983–985

Object Explorer, 92

deleting, 310–313

encryption, 853–859

external

distributed queries, 367–377

linking, 367–369, 374–377

OLE DB, 374

pass-through distributed

queries, 380

inserting, 292–302

integrity

data warehouses, 22

database, 18–19

DBCC, 593

entity-value pairs pattern,

163

normalization, 147

physical schema, 24

transactions, 381

triggers, 880

loading, data warehouses,

1147–1153

marts, 22

merging, 313–318

migration, Azure SQL Database,

807–829

model diagramming, 154

modifi cation, 291–322

Query Editor, 292

returning, 318–321

SSMS, 292

ownership, database security, 20

ranking functions, 259–269

replication, 727–744

agents, 731–732

confi guration, 732–743

merge publ icat ion, 741–743

peer-to-peer, 731, 740–741

servers, 727–729

types, 730–731

web synchronization, 743

sources

FROM, 117–120

declarative language, 220

inner joins, 220–221

multiple, 220–221

reports, 1235–1236

SSRS, 1271

Azure SQL Database, 801–830

SSAS, 1226–1228

SSRS, 1244–1250

storage, cubes, 1219

stored procedures

passing, 437–444

returning, 444–451

updates, 302–309

views, 271–289

windowing functions, 257–258

partition, 258

XML, 339–365

Data Alerts, SSRS, 1262, 1269, 1277

Data Bar, 1243

Data Center Edition, 35

Data Cleansing, 1181

Data Collector Sets, 913–914

bindex July 23, 2012 2:44 PM V1

bindex.indd 1353bindex.indd 1353 7/31/2012 10:39:56 AM7/31/2012 10:39:56 AM

http://www.it-ebooks.info