List of top new features of sql server 2008

List of 28 new features of Microsoft SQL Server 2008.

List of 28 new features of Microsoft SQL Server 2008.

1. Transparent Data Encryption
2. Extensible Key Management
3. Auditing
4. Enhanced Database Mirroring
5. Automatic Recovery of Data Pages
6. Log Stream Compression
7. Resource Governor
8. Predictable Query Performance
9. Data Compression
10. Hot Add CPU
11. Policy-Based Management
12. Streamlined Installation
13. Performance Data Collection
14. Language Integrated Query (LINQ)
15. ADO.NET Data Services
16. DATE/TIME
17. HIERARCHY ID
18. FILESTREAM Data
19. Integrated Full Text Search
20. Sparse Columns
21. Large User-Defined Types
22. Spatial Data Types
23. Backup Compression
24. Partitioned Table Parallelism
25. Star Join Query Optimizations
26. Grouping Sets
27. Change Data Capture
28. MERGE SQL Statement