A

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

accessing
     dimensions in Analysis Services 2005
     metadata
     properties in Analysis Services 2005
     Resource database
     system metadata
         catalog security 2nd
         catalog views 2nd
     system tables
activation
active-active clusters
Activity Monitor
    locking and blocking
         monitoring 2nd 3rd
Activity Monitor (SQL Server Management Studio
addressable memory
     of 64-bit processors
administering HTTP SOAP endpoints 2nd 3rd
Agent log files
     viewing 2nd
Aggregate transformation
alignment
ALTER INDEX statement
     T-SQL enhancment 2nd
ALTER permission
AMO
     implementing 2nd 3rd
     required assembly references
AMO (Analysis Management Objects 2nd 3rd 4th
Analysis Service projects 2nd
Analysis Services
     databases, backing up 2nd
    properties
         accessing
     security
         granular permissions 2nd
     selective aggregation
     UBO
     XMLA support 2nd 3rd 4th
Analysis Services 2000
     failover clustering support
     migrating to Analysis Services 2005
         Migration Wizard 2nd 3rd
Analysis Services 2005
    dimensions
         enhancements to 2nd
    new features
         Intellicube
         multiple fact tables
     Optimize Schema option 2nd
     partitioning 2nd
    security
         role-based 2nd
Analysis Services tasks
ANSI SQL-92
     SQL Server 2005 compliance
API management tools
     SMO 2nd 3rd 4th 5th 6th
     WMI 2nd 3rd 4th
APIs
     SNAC
     WMI 2nd 3rd
         SMO .NET object library
    WMIL
         managed objects
appdomains
     sys.dm clr
application design
    performance objectives
         .NET runtime integration
         asynchronous messaging
         HTTP SOAP support
         mutliple active result sets
         query notifications
         T-SQL enhancements
APPLY relational operator 2nd
assemblies
     catalog views 2nd
    dependencies
         viewing
     dropping from database
     in .NET Framework
     properties, modifying
     SQLCLR
assembly references
     AMO requirements
assigning permissions to signed module users 2nd 3rd
ASSL (Analysis Services Scripting Language)
associating
     xml data type with XSD schema
Association algorithm
asymmetric keys
asynchronous messaging 2nd 3rd
     benefits of 2nd
     database integration 2nd
asynchronous mode (database mirroring) 2nd
asynchronous triggers
     Service Broker solutions 2nd 3rd 4th 5th 6th
ATTACH REBUILD LOG clause
auditing 2nd
AUs (allocation units 2nd
authentication 2nd
     endpoint-based 2nd
         HTTP support
     limitations of in SQL Server 2000
     password policy support
         CREATE LOGIN DDL statement, options 2nd
         creating SQL Authenticated logins
         credentials
         disabling SQL Authenticated logins 2nd
         native password complexity
     SQL Browser 2nd
         running in low-privileged accounts
authoring
     reports 2nd
     SSIS packages 2nd
authoring tools [See management and authoring tools]
authorization
     granular permissions control
         ALTER permission
         CONTROL permission
         GRANT statement 2nd
         hierarchical permission model 2nd 3rd 4th
         IMPERSONATE permission
         object-scoped permissions
         server-scoped permissions
         TAKE OWNERSHIP permission
     metadata, securing 2nd 3rd 4th
     module execution context
         EXECUTE AS clause 2nd 3rd 4th 5th 6th
         limitations of ownership chaining 2nd
     terminology
     user-schema separation
         creating schemas 2nd
         default schemas 2nd 3rd 4th 5th
AUTO UPDATE STATISTICS ASYNC option 2nd
AUTO UPDATE STATISTICs ASYNC option
automatic failover
automating
     UBO
availability
     enhancements to 2nd
         database mirroring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
         database snapshots 2nd 3rd 4th 5th 6th 7th 8th 9th
         dedicated administrator connection 2nd
         early restore access 2nd
         failover clustering 2nd
         index operations 2nd 3rd
         instant file initialization 2nd
         mult-instance support
         replication 2nd 3rd
AWE
     dynamic AWE 2nd
     limitations of in 32-bit environments
AWE (Address Windowing Extensions) 2nd