MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

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