Microsoft® SQL Server® 2012 Bible

1352

Index

composite indexes, 1010

fi lter by ordered, 1029

fi lter by unordered, 1030

compression. See data compression

COMPRESSION, 561

compression information (CI), 1100

compute, 281

compute by, 281

computername, 779

CONCAT, 202–203

CONCAT_NULL_YIELDS_NULL, 520

conceptual model, relational

database design, 146

concurrency, 26–27

ACID, 26

indexes, 26

locks, 26

multiuser, 1094

scalability, 1047

Smart Database Design, 24

transaction isolation, 26

trigger code, 26

Conditional Split, SSIS Data Flow,

1180

conditions

multiple

joins, 231

WHERE, 127–128

PBM, 535–538

confi guration

advanced options, 478–480

advanced server, 504–509

ANSI, 514–521

Change Tracking, 946–950

clustering, 748–768

Failover Clustering, 750

Server authentication

Certifi cate, 750

Server Role Services, 749–750

SSL, 750

validating, 750–751

Windows Server

2008/2008R2, 748–762

connections, 475–476, 499–504

cursors, 513–514

data replication, 732–743

database, 474–475

access, 523–524

auto options, 510–512

compatibility, 524–525

mirroring, 693–694

SSMS, 475

state, 522–525

instances, 51–52

log shipping, 666–677

SSMS, 667–675

T-SQL, 675–676

MDW, 978–982

memory, 483–488

options, 469–529

recovery, 525–529

security, 496–498

server, 471–474

SSAS, 1223–1232

start/stop, 480–483

Surface Area Confi guration

Wizard, 477

triggers, 521–522

Confi guration Manager, 9–10

startup parameters, 480–482

Confi guration screen, Database

Engine, 54–55

/CONFIGURATIONFILE, 59

connected objects, 790

Connection, 1172

connections

ANSI, 475, 476

confi guration, 475–476, 499–504

Enforce DTC, 503

maximum concurrent user

connections, 501

network packet size, 504

nulls, 476

objects, 790

query governor cost limit,

501–502

remote access, 502–503

remote login timeout, 503

remote query timeout, 503

SET, 476

SSMS, 500

connection bar, Query Editor, 100

connection fi le library, Power View,

1330

Connection Managers, SSIS, 1161–

1169

ADO.NET, 1168

DQS, 1168

fi les, 1168–1169

Flat File, 1162–1163

FTP, 1169

HTTP, 1169

MSMQ, 1169

OLE DB, 1164, 1168

security, 1168

SMOs, 1169

SMTP, 1169

SQL Server Mobile, 1168

SSAS, 1168

WMI, 1169

ConnectionType, 1171–1172

consistency. See also atomic,

consistent, isolated, and

durable

data warehouses, 1147

stored procedures, 431

transactions, 732, 1048–1049,

1090

constraints

indexes, 1010

objects, 791

physical schema, 24

SSIS, 1174

containers, SSIS, 1170

context menu

SSMS, 85

views, Object Explorer, 275

CONTINUE, WHILE, 402

CONTINUE_AFTER_ERROR, 561, 565

Control Flow, SSIS Designer, 1159,

1161, 1169–1175

precedence, 1174–1175

tasks, 1170–1174

conversationhandle, 651

conversion functions, data types,

207–210

CONVERT(), 207–210

scalar subqueries, 240–241

Copy Column, SSIS Data Flow, 1180

Copy Database Wizard, 293

data replication, 729

database transfer, 616–619

SMOs, 617

SSIS, 616

copy-on-fi rst-write, database

snapshots, 637

copy-only recovery model, 549

core-based licensing, 40–41

correlated subqueries, 244–246

correlated UDFs, 460–461

cost threshold for

parallelism, 493–495

COUNT(), 185, 252

count(*), 1099

Count[_big](), 250

counters

SQL Profi ler, 919

System Monitor, 910–913

Counter Logs, Performance Monitor,

925–926

covering index query path,

1024–1027

CPU. See processor

CREATE, 276, 794

data compression, 1105–1106

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info