U

UDM (Unified Dimensional Model) components, SSAS, 182–183

UDT (user defined data type), SQL Native Client used by, 5

UMS (User Mode Scheduler), 389–390

Unified Dimensional Model (UDM) components, SSAS, 182–183

uninstalling SQL Server, 44–47

Upgrade Advisor

definition of, 56

installing, 57

report generated by, 60–61

scripting, 60

using, 58–59

Upgrade Assistant, 62–64

upgrade installation, 28

upgrading to SQL Server 2005

backward compatibility issues, 64–66

components affected by, 66–72

configuration for, 74–76

from full-text catalog, 66

in-place upgrade, 54–55, 56

performance affected by, 72–74

planning requirements for, 53

post-upgrade tasks, 53, 72–76

potential issues regarding, identifying and resolving, 56–61

pre-upgrade checks, 56

Raymond James Financial evaluation of, 701–706

reasons for, 51–53, 702, 706

side-by-side upgrade, 55–56

with SQL Server Upgrade Assistant, 62–64

strategies for, 53, 55–56

troubleshooting, 72–76

usage counters

memory usage counters, 414–417

processor usage counters, 406–408

updating after upgrading, 76

Usage-Based Optimization Wizard, 204–206

user defined data type (UDT), SQL Native Client used by, 5

User Defined Functions, SSAS, 75

user mode, 399

User Mode Scheduler (UMS), 389–390

user-defined aggregates, CLR, 288

user-defined types, CLR, 288–289

users. See also logins for SQL Server instance

associated with logins, 303

auditing activities of, 417

connections by, monitoring, 437

creating with T-SQL, 306

errors by, causing database failure, 592

granular permissions for, 304–305

monitoring, 92–93

performance considerations for, 343

roles for, 306

/USERVA setting, boot.ini file, 345, 357

"Using SQL Server Profiler" (Books Online topic), 425