Chapter 15 DBMS-Specific Features

Microsoft SQL Server 2005

This section describes features specific to Microsoft SQL Server 2005. For information about features available with earlier versions, see also Microsoft SQL Server 7.x and 2000.

The following new features are available for Microsoft SQL Server 2005:

• Horizontal partitioning - implemented via:
  
  
  • Partition functions
  • Partition schemes
• Common Language Runtime (CLR) integration - implemented via:
  
  
  • CLR assemblies
  • CLR aggregate functions
  • CLR user-defined types
  • CLR procedures and functions
  • CLR triggers
• Encryption – implemented via:
  
  
  • Certificates
  • Asymmetric keys
  • Symmetric keys
• Full text search – implemented via:
  
  
  • Full-text catalogs
  • Full-text indexes
• XML indexing – implemented via:
  
  
  • XML indexes
• XML data types – implemented via:
  
  
  • XML schema collections
  • XML table columns
• Synonyms
• Database mirroring
  
  
  • Databases
  • Endpoints
• Service Broker
  
  
  • Message types
  • Contracts
  • Queues
  • Event Notifications
  • Services
  • Routes
  • Remote service bindings
• Microsoft SQL Server 2005 Analysis Services – generation and reverse-engineering of cubes
• Miscellaneous additional features

Copyright (C) 2007. Sybase Inc. All rights reserved.