Microsoft® SQL Server® 2012 Bible

1350

Index

BLOCKSIZE, 561

body, reports, 1251

BOL. See Books Online

bookmarks, Query Editor, 102

bookmark lookup query path, 1022–

1024, 1033

Bookmarks window, SSMS, 83

Books Online (BOL), 11

Azure SQL Database, 814–815

Border, Report Designer Text Box

Properties window, 1244

Boyce-Codd normal form (BCNF),

169

BPA. See Best Practices Analyzer

breadth-fi rst, to hierarchy indexes,

334

BREAK, WHILE, 402

BROKER_INSTANCE, 648

browse_information_mode, 409

B-tree

data compression, 1100

indexes, 1006–1007

bubble charts, Power View,

1340–1342

Buffer Manager, 6, 911

buffer overfl ow, 737

BuiltinAdminsAreServerAdmins,

1228

BULK COPY, 301

bulk copy program (bcp), 11, 429, 728

Azure SQL Database, 826–829

Bulk Copy Wizard, 293

BULK INSERT, 301, 425–428

Bulk Insert, SSIS Control F

low, 1171

bulk operations

recovery, 548–549

T-SQL, 424–428

bulk-loaded recovery model

performance, 553

sequence, 569

transaction logs, 554

bulk-logged, 687

BULK_LOGGED, 554

bulk-logged recovery model, 526,

548, 550, 553–554

Business edition, Azure SQL

Database, 805

business entity layer, 164

business intelligence (BI), 7–9, 22

data warehouses, 1143–1153

database design, 1143–1153

OLAP, 1143–1144

OLTP, 1143

SSMS, 81

Business Intelligence Development

Studio (BIDS), 1195, 1226

BISM, 1301

SSAS data mining, 1283

Business Intelligence Edition, 12

Power View, 1327

Business Intelligence Semantic

Models (BISM)

ad hoc reports, 1234

SQL Server Data Tools (SSDT) for

BIDS, 1301

connection fi le, Power View,

1332–1334

creating and deploying models,

1299–1326

Power View, 1235, 1329

PowerPivot

creating model, 1303–1307

extending model, 1307–1317

SharePoint, 1301, 1317–1318

SSAS instances, 1324–1325

SSDT, 1301–1302

creating models, 1319–1322

extending models, 1322–1324

C

-c, 482

C Data Type Extensibility, 71, 77

C2 audit tracing, 497–498

cache. See also Plan Cache

proactive, 1225

SSAS data mining, 1286

SSIS

Connection Managers, 1169

Data Flow, 1180

caching data stores, 21

calculations, cubes, 1213

CalledProc, 423

candidate key. See primary key

@captured_column_list, 956

@capture_instance, 956

cardinality

PK, 152–153

relational database design,

152–153

cards, Power View, 1342–1344

Cartesian Product, 229

CASCADE, WITH GRANT OPTION, 847

cascading deletes, 311–312

cascading logical deletes, 313

CASE

aliases, 183

Boolean, 183–184

expressions, 181–184

NULL, 183

ORDER BY, 133

simple, 182–183

THEN, 183

WHEN, 183

case, 133

case-sensitivity, 119

CAST(), 207

scalar subqueries, 240–241

cast(), 302

Catalog Views, Service Broker, 657

catch, rollback transaction,

1051

CATCH blocks, 419–422

cause-and-effect relationship,

layers, 28

CDC. See Change Data Capture

cdc. change_tables, 956

cdc.captured_columns, 956

cdc.ddl_history, 956

cdc.fn_cdc_get_net_changes,

961–962

cdc.index_columns, 956

cdc.lsn_time_mapping, 956

CEC. See common engineering

criteria

CEILING(), 1187

ceiling(), 178

Central Management Server, 88

certifi cates

backup, 854

encryption, 854, 859

Server Authentication

Certifi cate, 750

Change Data Capture (CDC), 954–965

AlwaysOn Replicas, 954

DML, 954

triggers, 961

enabling, 955–957

ETL, 954

LSNs, 954, 958–959

net changes, 961–962

Object Explorer, 956

OLTP, 954

queries, 959–963

removing, 964–965

Splitter, SSIS Data Flow, 1180

SSIS

Control Flow, 1171

Data Flow, 1177, 1180

transaction logs, 954

Change Tracking

alter, 948

auto_cleanup, 947

confi guration, 946–950

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info