Index_U

U

Unicode data types, 226-227

Uninstalling SQL Server in a cluster, 412-413

UNION ALL statement, 246, 316, 326

turning into a pass-through query, 320

vs. UNION statement, 241

UNION statements, avoiding using, 241

Unique keys (table), generating, 195

UPDATE statements, 230

UPDATE STATISTICS, 46, 295

Update Statistics Prior To Detach option, 294

Updating DPVs, 331-332

Updating statistics on selected tables, 174

Upgrade Wizard, 18, 20-21

Upgrading SQL Server

avoiding replication problems when, 21

from a beta version, 21

and detaching/attaching databases, 297

from an evaluation edition, 21, 297

from SQL Server 4.2, 16-17

from SQL Server 7.0, 18-20

from SQL Server 6.0 or 6.5, 17-18

tricks and tips for, 20-22

Upgrading stored procedures, 20

UPS, 184

Uptime (the nines), 262, 344

Uptime percentages, 262, 344

Use Existing Database option, 356

User database roles, 65-66

User names mapped to database roles, 473

User password, hacker finding out, 88

User processes currently running, listing, 466-467

User rights and permissions, listing, 492-493

User-defined data types

listing for a database, 475-476

replication and, 430

User-defined databases, upgrading and, 18

User-defined errors, raising, 137-138

Users

disconnecting, 219-221

listing for a database, 476-477

listing for linked servers, 465

vs. logins, 290

Users security level, 60

usp_ stored procedures, naming of, 223

usp_databases, 160-161

usp_killusers, 219-221, 294