UDTs (user-defined types)
CLR, 444–445
Transact-SQL, 443
unattended report execution, 343
understandable data, 402
Unicode character strings, 442
UNION ALL operators, 417–419, 418–419
Union All transforms, 377
UNION hint, 91
UNION operators, 417–419, 418–419
unique constraints, 435
uniqueidentifier data, 429, 430, 443
Unpivot transforms, 377
unrestricted joins, 415–417, 416
updatable copies, single master approach, 429–432, 429–431
updatable subscribers, conflicts with, 505–506, 506
UPDATE STATISTICS statement, 88, 113
updates
catalogs, 316–317
deploying, 566
index statistics, 111–114
security, 565–566
subscribers
snapshot replication with, 430–431, 431
transactional replication with, 431–432
UPDATEUSAGE command, 51, 316–317
UPDLOCK hint, 140
% Usage counter
baselines, 230
thresholds, 236
USE PLAN hint, 91
Use Remote Collation option, 463
UseInprocLoader parameter, 509
User Connections counter, 233
user-defined integrity, 434
user-defined roles, 584
user-defined types (UDTs)
CLR, 444–445
Transact-SQL, 443
user-level security
authentication, 575–578, 576
implementing, 583–586, 583
logins. See logins
permissions, 586–589, 586–588
User Must Change Password at Next Login option, 576–577
User Settable counter, 225
User Statistics reports, 50
USEROPTIONS command, 51
users, database, 583, 583
@useself parameter, 466