Microsoft® SQL Server® 2012 Bible

1351

Index

data, 945–954

database, 946–947

DMVs, 949

indexes, 949

internal tables, 949–950

PK, 949

queries, 950–953

removing, 953

SSMS, 948

tables, 948–949

T-SQL, 948

versions, 950–951

ChangeCapture, 37

ChangeTable, 951

Channels, Extended Events, 941

Char(), 174

char, 174

character data types, 174

Character Map, SSIS Data Flow, 1180

CHARINDEX(), 198

Chart, 1243

charts

lift, 1286–1287

mini-, 1254

Power View, 1335–1338

bubble charts, 1340–1342

scatter charts, 1340–1342

CHECKPOINT, 564

checkpoints, transaction logs,

564–565

CHECKSUM, 526

backup, 561

Checksum_Agg, 251

CHOOSE, 184–185

CI. See compression information

Classifi cation, SSAS data mining,

1281

Classifi cation Matrix, SSAS data

mining, 1287

classifier, 1135, 1138

client

application, 17

connectivity, 71–80

Power View, 1328

SSAS, 1225–1226

Client Tools, 1262

ClientConnectionID, 77

CLR. See Common Language

Runtime

clr enabled, 493

Cluster Validation Report, 753

ClusteredIndexes, 795

clustering, 745–768

confi guration, 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

creating new, 753–755

high-availability, 746–747

indexes, 1007–1008

data compression, 1098

foreign keys, 1033

linked lists, 1008

rows, 1033

scan, 1001

seek query path, 1017–1018,

1019

selecting, 1033

instances, 756–762

DTC, 756–757

network confi guration, 748

online, 747

scalabil it y, 746–747

SSAS data mining, 1291–1292

cmd.exe, 771

cmdlets, PowerShell, 770–777

modules, 784–785

COALESCE, 398

COALESCE(), nulls, 186–187

Codd, Edgar F., 147, 213, 216

code snippets

SSMS, 106

T-SQL, 82

CodePlex.com, 11

COLLATE, LIKE, 126

collation

distributed queries, 385

ORDER BY, 135–136

collections, 772

columns

AFTER, 881

aliases, 128–129

ORDER BY, 134–135

SELECT, 279

views, 279

ORDER BY, 132–133

ordinal numbers, ORDER BY, 135

physical schema, 24

projected, 272

relational database design,

145–146

security, views, 273

SELECT, 235, 394

SQL Profi ler

organizing, 924

selecting, 921–923

SSIS Data Flow, 1177

UNION ALL, 235

XML, 350–351

Column Expressions, 115

column-level confl ict tracking, 732

columnstore indexes, 16, 27, 1038

columns_updated(), 179

AND, 888

GenColUpdated(), 888

varbinary, 887

comma-delimited fi les (CSV), 425

PowerShell, 917

command events, 1230

command objects, 790

command-line utilities, 11

database management, 612

installation, 58–60

comments

PowerShell, 773

T-SQL, 392–393

COMMIT TRAN, 420

commit transaction, 1050,

1090–1091

deadlocks, 1063

Common Criteria, traces, 929

common engineering criteria (CEC),

770

Common Language Runtime

(CLR), 4

HierarchyID, 326

SQL Profi ler, 921

UDT, 78

XML, 347

common table expressions (CTEs),

392

FROM, 117

WITH, 239

difference unions, 236

hierarchies, 335–336

nested, 240

simple subqueries, 239–240

statements, 137

syntax, 240

UNION ALL, 240

Compact Edition, 36

comparators, 940

comparison operators, 121

Extended Events, 940

PowerShell, 773

compatibility. See also backward

compatibility

database, confi guration,

524–525

Component Services, DTC, 383

bindex July 23, 2012 2:44 PM V1

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

http://www.it-ebooks.info