A

access method, SQL Native Client as, 5

accounts for Database Mail, 130, 131

accounts for services

security considerations for, 27

for SQL Server Agent, 118

types of, 28

accounts for SQL Server. See also logins for SQL Server instance

guest account, 301

mapping to Windows account with credentials, 302

to start SQL Server, 78

accounts for SQL Server Agent

proxy accounts, 119–122

service account, 118

accounts for Windows, mapping SQL Server account to, 302

ACID (atomicity, consistency, isolation, durability) properties, 594

active/active clusters, 660–661

active node, for clustering, 654, 657–658

active/passive clusters, 660

ActiveX scripts, 106

Activity Monitor, Management Studio

active connections, information about, 92–93

definition of, 92, 404

disconnecting processes, 93

lock information, viewing, 94–95

actual execution plan, 459–462

(A-DBN) token, 134

Address Window Extensions (AWE)

dynamic, support for, 15

enabling, 393

managing, 395

optimization using, 358–359

tuning memory using, 389

Ad-Hoc Data Mining Queries, SSAS, 75

Ad-Hoc Remote Queries

configuring, 80

default settings for, 75

admin tools, installing on remote cluster nodes, 48

administrators

dedicated connection for, 15

permissions for, configuring, 42

AdventureWorks database, installing, 34–37

(A-ERR) token, 134

affinity mask, 397–398, 400–401

Agent, SQL Server

alerts in, 113–118

components of, 105

configuring, 123–127

jobs in

categories for, 107–108

logging, 108

notifications from, 108–109

running, methods for, 106

types of, 106–107

log shipping processes using, 631

operators in, 110–113

proxy accounts for, 119–122

replication using, 531

roles having access to, 118–119

scheduling jobs in, 109–110

scheduling SSIS package execution, 173–175

security for, 118–122

service account for, 118

starting automatically, enabling, 105

stopping before running in single-user mode, 83

subsystems, 119–120

troubleshooting, 141–143

aggregate binding, for query, 447–448

aggregate reduction of query, 450–451

Aggregation Design Wizard, 204

aggregations for SSAS, 204–206

alerts, in SQL Server Agent

configuring, 124–125

definition of, 113–114

operators notified when alerts occur, 110–113

responses to, 117–118

SQL Server event alerts, 114–115

SQL Server Performance Condition alerts, 115–117

for WMI events, 137

algebrization phase of query compilation, 439, 447–448

ALTER ASSEMBLY statement, 285

ALTER DATABASE statement

database mirroring modes, setting, 549, 565, 566–567

switching recovery models, 598

ALTER ENDPOINT statement, 555

ALTER INDEX statement, 483

ALTER MESSAGE TYPE statement, 216

ALTER QUEUE statement, 220, 221

ALTER TABLE statement, 9

ALTER_DATABASE events, 329

(A-MSG) token, 134

Analysis Services, SQL Server (SSAS)

Ad-Hoc Data Mining Queries, 75

aggregations for, designing, 204–206

Anonymous Connections, 75

components of, 182–184

configuring, 75

database roles for, 207–210

databases for

backing up and restoring, 194–197

deploying, 188–191

processing, 191–194

synchronizing, 197–198

definition of, 182

Flight Recorder for, 200–201

installing, 37

jobs executing commands or queries from, 106–107

Linked Objects, 75

lock manager properties for, 184

log properties for, 184

memory properties for, 185

network properties for, 185

OLAP properties for, 185

partition configuration for, 202–204

performance monitoring for, 198–201

profiling of, 424

required services for, 186

scripting language for, 186–187

security for, 206–210

security properties for, 186

server configuration for, 184–186

server roles for, 206–207

storage used by, managing, 201–206

support for, by SQL Server edition, 14

traces for, 199–201

uninstalling, 46–47

User Defined Functions, 75

Anonymous Connections, SSAS, 75

AppDomain (Application Domain), 273, 274–275, 289–290

AppleTalk, 65

application errors, causing database failure, 592

application event log, 115

application load generator, 378

archiving data, 623–624

(A-SEV) token, 134

assembly for CLR

altering, 285

catalog view of, 286

creating, 277–280

deploying, 280–286

dropping, 285–286

registering, 282–285

security for, 281–282

(A-SVR) token, 134

asynchronous mirroring mode, 550

asynchronous statistics update, 482

atomicity, consistency, isolation, durability (ACID) properties, 594

authentication

configuring, 88

for SQL Server logins, 293–294

for transport security, 243–246, 263

automatic failover, database mirroring, 549, 558–559, 563–565

AUTO_UPDATE_STATISTICS setting, 65

average page density fragmentation, 475

AWE (Address Window Extensions)

dynamic, support for, 15

enabling, 393

managing, 395

optimization using, 358–359

tuning memory using, 389