Chapter 15 DBMS-Specific Features

Microsoft SQL Server 2005

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
• Miscellaneous additional features

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