You are here:Home » tsql » What's New in SQL Server 2008

What's New in SQL Server 2008

After releasing of SQL Server 2008, We got to feel very easy because so many new features and enhancements introduced by SQL Server 2008.

I enjoyed my work while worked with SQL Server 2008 new features as well new enhancements. Some of the new features lists I have drafted. Links are available for each feature list if posts are available for the same. Please go through below list and let me if I missed anything.
  • HierarchyId new data type
  • Policy based management
  • Performance Data Collection
  • Data compression
  • Resource Governor
  • Transparent Data Encryption
  • External Key Management/Extensible Key Management
  • Data Auditing
  • Hot-Add CPU and Hot-Add Memory
  • Streamlined Installation
  • Server Group Management
  • Upgrade Advisor
  • Partition aligned indexed views
  • Backup Compression
  • Extended Events
  • Grouping Set
  • Merge Statement
  • Greater Support for LINQ and Entity Framework
  • Change Data Capture
  • Table Valued Parameters
  • Entity data model for entity framework.
  • Synchronization Server with ADO.NET
  • CLR Improvements
  • Conflict detection between peer to peer Replication
  • Service Broker Priorities and Diagnostics
  • Spatial Data with Geography and Geometry data types
  • Virtual Earth Integration
  • Sparse Column
  • Filtered Indexes
  • Integrated full text search
  • File stream data
  • Large user defined types
  • Large user defined aggregates
  • Date/Time Data Types
  • Improved XML Support
  • ORDPATH
  • TSQL Debugger
  • Intellisense

I will post for each feature list in details and with examples in future.