U

UCS (Unicode Character System), 72

UDFs (user-defined functions), 13, 38, 437

UDTs (user-defined types), 377–378

unary operators, 293, 298

uncommitted dependency, 488–489

underscore (_) signs, 329

undo files, standby server, 234

Unicode Character System (UCS), 72

Unicode data types, 304–305, 312, 314

UNICODE function, 608

Unicode string constants, 292

UNlCODE(unicode expression) function, 317

uniform extents, 40

UNION function, 608

UNION operator, 475–476

UNIQUE constraints, 33, 35, 166, 168, 376

unique key constraints, 374–375, 430

uniqueidentifier, 608

uniqueidentifier constants, 293

uniqueidentifier data type, 307–308

UNLIMITED keyword, 149, 155

unsynchronized mirroring, 244

updatable partitioned views, 479–482

updatable subscriptions, 219–220

update (U) locks, 492, 494

UPDATE statements, 166, 389, 436–439, 441–442, 526, 608

UPDATE STATISTICS statement, 608

updategrams, 523–526

updates

cascaded, 6

data, 450

UPDATETEXT statement, 608

UPPER function, 317, 609

urgent restore, 183

usage, key, 117

USE function, 609

User Accounts, 115

user connections, 555

user databases, 22, 28

user files, 24

USER function, 609

user identification (user ID), 101, 165

user interface, 5

User Mapping page, 131

User settable SQL Server object, 548

USER_ID function, 609

USER_NAME function, 609

user-defined data types, 37–38

user-defined filegroup, 42

user-defined functions (UDFs), 13, 38, 437

user-defined roles, 121

user-defined stored procedures, 413

user-defined types (UDTs), 377–378

user-mode execution, 54

users

built-in, 118

database, 146

SQL Server, 132–133