A

account lockout policy, explanation of, 20

Accumulate aggregate method

description of, 86

example of, 88

ACFs (application configuration files)

specifying in nscontrol, 123

using with Notification Services, 111–113

ACTIVATION keyword, using with SQL Server Service Broker application, 135

activation of SQL Service Broker, implementing, 130

Active-Active and Active-Passive clustering, setting up, 51

ActiveViews, availability in Reporting Services, 173

Add New Item window

adding CLR stored procedures from, 72–73

creating UDAGGs in, 86

creating UDTs in, 81

using with UDFs, 76

AddSubscriptions method, using with Notification Services, 124

ADF event schema, defining for Notification Services application, 113–115

ADF notification schema, creating for Notification Services application, 118–120

ADF providers, defining for Notification Services applications, 115–116

ADF subscription schema, defining for Notification Services applications, 116–118

ADFs (application definition files), using with Notification Services, 111–112

administrators. See dedicated administrator connection

ADOMD.NET, relationship to Analysis Services, 236–237

ADO.NET enhancements

asynchronous queries, 98–99

bulk insert, 102–103

common connection model in, 103–104

MARS (Multiple Active Results Sets), 100–101

overview of, 96

for paging, 101–102

server cursors using SqlResultSet, 97–98

ADO.NET objects, using with UDTs, 78–79

ADO.NET, relationship to .NET data providers, 70

AdventureWorks database

creating extended triggers in, 80

HumanResources.Employee table in, 90–91

using ADO.NET bulk insert feature with, 102–103

using .NET stored procedures with, 74

AdWSnapShot_080104_0700 Database Snapshot, creating, 56

aggregated views feature of Profiler, description of, 45

aggregation functions, availability of, 85–86

airline reservation systems, using queuing with, 127

ALTER DATABASE command

enhancements in, 9

using with Database Mirroring, 54

ALTER TABLE statements, using DDL triggers with, 93

ALTER* permissions, descriptions of, 20

ALTER* T-SQL DDL statements, descriptions of, 133

AMD 64-bit processors, support for, 4–5

AMO (Analysis Management Objects), features of, 47, 237

Analysis Manager, replacement of, 225

Analysis Server scripts, using with Solution Explorer, 32

Analysis Services

and ADOMD.NET, 236–237

and AMO (Analysis Services Management Objects), 237

backup and restore enhancements in, 225

Cube Browser feature in, 232–233

Cube Editor feature in, 230–232

Cube Wizard feature in, 228–230

and data mining, 237–238

developing applications in, 226

engine enhancements in, 218–221

and failover clustering support, 219

integration with .NET Framework, 219

localization enhancements in, 221

management enhancements in, 222–225

MDX enhancements in, 235–236

ODL enhancements in, 235

orphaned fact table row support in, 221

overview of, 217

Profiler feature in, 233–234

profiling, 44

scripting support in, 221

security enhancements in, 224–225

starting and stopping, 222–225

trace support in, 221

trigger support in, 220–221

and UDM (unified dimensional model), 219–220

using fine-grained administrative privileges with, 224–225

using MDX Query Editor with, 223–224

using OLAP Report Designer with, 168–169

using SQL Server Computer Manager with, 222

using SQL Server Management Studio with, 223–224

XML enhancements for, 157–158

XMLA feature in, 234–235

Analysis Services projects, using in Business Intelligence Development Studio, 36

anchor members, using with CTEs, 91

Application objects, using with Notification Services, 124

ApplicationDefinitionFilePath tag in config.xml file, significance of, 113

ApplicationExecutionSettings element of ADF, description of, 120

ApplicationName tag in config.xml file, significance of, 113

Arguments element of ADF, description of, 116

AS SNAPSHOT OF clause, using, 56

ASPs (application service providers), using multiple instance support with, 218–219

assemblies

creating and removing, 68–70

creating for UDFs, 77

creating from MyCLRDLL.DLL, 74

using EXTERNAL NAME clause with, 75

Association Rules algorithm, relationship to data mining, 238

asynchronous queries, ADO.NET support for, 98–99

asynchronous queuing. See SQL Server Service Broker

automatic type conversion, availability in MDX, 236

availability enhancements

Database Snapshots, 56–58

dedicated administrator connection, 60

Early Restore Access, 58–59

fine grained online repairs, 60

Hot-Plug memory, 61

improved dynamic configuration, 61

online index operations, 59–60

overview of, 55–56

transaction isolation levels, 61–62

AWE (Advanced Windowing Extensions), support for, 5