Microsoft® SQL Server® 2012 Bible

1380

Index

tables. See also common table

expressions (cont inued)

switching, 1125–1127

physical schema, 24

Power View, 1334

query recompiles, 1045

relational database design,

145–146

reports, 1251

returning data, 320–321

schemas, 171

security, 861

Security, 862–863

foreign keys, 862

PersonLogin, 874

stored procedures, 442–444

subqueries, 242

temporary

global, 407

local, 406

T-SQL, 406–407

views, 280

UPDATE, 303–304

variables, T-SQL, 407–408

Table, Report Designer Toolbox,

1242

Table Designer

scripts, 620

SSMS, 94–95

Table Lock, 1066

Table Partitioning, 37

Table Properties, SSMS, 1103

table scan, 1001, 1013

tablesample, 280

TABLOCK, 589

TabLock, 1086

BULK INSERT, 427

Tabular mode, SSAS, 1223

targets

Extended Events, 939–940

SQL Audit, 969–970

target service, 649

TargetDataSetFolder, 1266

TargetDataSourceFolder, 1266

target_percent, 601

TargetReportFolder, 1266

TargetReportPartFolder, 1266

TargetServerURL, 1266

TargetServerVersion, 1266

Task List, SSMS, 83

TaskHost, SSIS container, 1170

TCP. See Transmission Control

Protocol

TCP/IP. See Transmission Control

Protocol/Internet

Protocol

TDE. See Transparent Data

Encryption

Tee-Object, 775

templates

SSMS, 106

T-SQL, 82

Template Explorer, 83

temporary buckets, 24

temporary keys, 857

temporary tables

global, 407

local, 406

T-SQL, 406–407

views, 280

Term Extraction, 1182

Term Lookup, 1182

ternary relationship, 170

testing

availability, 662–663

nulls, 185–186

unit, data integrity, 19

Text, 174

text, 174

Text Box Properties window, Report

Designer, 1243–1244

Textbox, 1242

Thawte, 859

THEN, 183

Q (theta) joins, 231

third normal form (3NF), 168–169

three-way relationship. See ternary

relationship

throttling, 806–807

THROW

CATCH blocks, 420–423

stored procedures, 450

Time(), 176

time series, SSAS data mining,

1282, 1296

TimeFromParts(), 197

Timestamp, 176

Tinyint, 175

ToDateTimeOffset(), 192, 195

ToFileOnly, 795

Toolbox

Report Designer, 1241–1243

SSIS, 1160

SSMS, 83

TOP()

ORDER BY, 139

random rows, 141

SELECT, 138–141

WITH TIES, 140–141

TopProc, 423

TORN_PAGE_DETECTION, 526

ToString(), 327

-Trace#, 482

traces. See also SQL Trace

blackbox, 929

Common Criteria, 929

preconfi gured, 928–929

SQL Profi ler, 10

defi ning new, 920–921

@@TranCount, 405, 1052–1053

transactions, 1047–1095. See also

online transaction

processing

ACID, 1048–1049

active, 563

aggregations, triggers, 896–900

atomicity, 1048

blocks

Activity Monitor, 1057–1058

default, 1054–1056

monitoring, 1057–1060

OLTP, 1093

SQL Profi ler, 1058–1059

SSMS reports, 1057

consistency, 732, 1048–1049,

1090

data integrity, 381

database mirroring, 687

DDL triggers, 906

deadlocks, 1060–1066

distributed, 381–383, 687

DML, 1049–1050

durability, 1049

implicit, 1053

inactive, 563

isolation, 1047, 1049

ANSI, 1071

concurrency, 26

levels, 1070–1086

locks, 1066

locks, 1047

contention, 1068

default, 1054–1056

granularity, 1066–1067

isolation, 1066

mode, 1067–1069

monitoring, 1057–1060

queries, DMVs, 1059–1060

logical, 1050–1051

MERGE, 1049–1050

nested, 1052–1053

objects, 791

performance, 1093–1095

programming, 1049–1054

Query Editor, 1055

replication, 730

bindex July 23, 2012 2:44 PM V1

bindex.indd 1380bindex.indd 1380 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM

http://www.it-ebooks.info