SQL Server 2008 Features

1. New index types


2. New Data Types


3. Intellisense


4. Performance Data Collection with Performance Studio


5. Policy-Based Management


6. Data Compression


7. Resource Governor


8. Transparent Data Encryption


9. Database Mirroring


10. Auditing


11. Change Tracking and Change Data Capture


12. LINQ


13. Multi-server script execution


14. Extended events


15. Integrated Full-Text Search


16. Sparse columns


17. PowerShell integration


18. For more feature