Microsoft® SQL Server® 2012 Bible

1382

Index

truncate table, 949

TRUNCATEONLY, 601

TRY...CATCH

deadlocks, 1064

INSERT, 313

nested, 423–424

RAISERROR, 450

transaction write confl icts, 1085

T-SQL error handling, 418–424

Try_Parse(), 209–210

T-SQL. See Transact-SQL

T-SQL for XML clause, 340

Tuning Advisor, Database Engine,

11, 1033

SQL Profi ler, 925

tuples, 165

two digit year cutoff, 508–509

2 X NC index query path, 1027–1029

2NF. See second normal form

type, 160

typed XML, 345–346

U

UDFs. See user-defi ned functions

UDM. See Unifi ed Dimensional

Model

UDT. See User Defi ned Types

/UIMODE, 59

UNBOUNDED FOLLOWING, 266

UNBOUNDED PRECEDING, 266–267

UNC. See Universal Naming

Convention

UNDO, DELETE, 310

Unicode data types, 174

Unifi ed Dimensional Model (UDM),

SSAS, 1197

Uniform Resource Names (URN),

SMOs, 784–785

UNION

GROUP BY, 254

SELECT, 302

unions

intersection, 235–236

in relational algebra, 213,

233–246

UNION ALL, 234–235

CTEs, 240

partition view, 1114

Union All, SSIS Data Flow, 1182

unique indexes, 1010

UniqueIdentifier, 176

unit testing, data integrity, 19

Universal Naming Convention

(UNC), 555

UNIX, PowerShell, 771

UnknownMember, cubes, 1221

UNLOAD, backup, 562

unordered heaps, indexes, 1012–

1013

Unpivot, SSIS Data Flow, 1182

untyped XML, 345–346

UPDATE, 111, 291, 302–309, 389

FROM, 304–305, 890

CTEs, 335

IF EXISTS, 313

INVENTORY, 900

Inventory_Aggregate, 900

OpenQuery(), 380

partition views, 1115–1116

Query Optimizer, 302–303

returning data, 319

SELECT, 292

tables, 303–304

transactions, 1049–1050

triggers, 879

multiple-rows, 889–891

views, 283

Update, 1087

update, 97, 874

CDC, 954

nested triggers, 522

updates

data, 302–309

data compression, 1103

InventoryTable, 896

locks, 1068

lost, 1088–1089

object permission, 844

row-level security, 868–870

views, 282–283

indexed, 1038

UPDATE STATISTICS, 597

UPDATE(), 886–887

/UPDATEENABLED, 59

/UPDATESOURCE, 59

UPDATETEXT, 553

@updateusage, 599

Updlock, locking hints, 1086

UPPER(), 199

URN. See Uniform Resource Names

usability

database, 17

normalization, 148

USE, batches, 391

use database, Azure SQL

Database, 812

UseParentSetting, 1188

User Confi gurable, SQL Profi ler, 922

user connections, SSMS, 501

User Defi ned Types (UDT)

CLR, 78

SNAC, 73

user information functions, scalar

functions, 191

User Variables, 1185–1186

user-defi ned database roles, 844

hierarchies, 848–849

lists, 849–850

managing with code, 848

user-defi ned functions (UDFs), 17,

453–465

FROM, 117, 453

APPLY, 460–461

best practices, 464–465

correlated, 460–461

entity-value pairs pattern, 163

inline table-valued functions,

458–462

multistatement table-valued

functions, 462–464

naming conventions, 465

performance, 464–465

scalar functions, 455–457

schema binding, 461–462

SELECT, 453

SSMS, 454

views, 272

WHERE, 453

user-defi ned integrity, 19

USER_NAME(), 191

@useself, 373

UTF-16

SNAC, 71

XML, 340

Utility Control Point, PowerShell,

783

Utility Explorer, 83

V

value(), 353–354

values(), 117

Var, 250

VarBinary, 177

varbinary, 887

VarBinary(), 176

VarChar(), 174

varchar, 174

@Variable, 396

variables

DECLARE, 393

default, 393–394

incrementing, 396

multiple assignment, 397–399

NULL, 393–394

parameters, RAISERROR, 415

bindex July 23, 2012 2:44 PM V1

bindex.indd 1382bindex.indd 1382 7/31/2012 10:40:00 AM7/31/2012 10:40:00 AM

http://www.it-ebooks.info