SQL 2008 Features

1. Plug-in model for SSMS
2. Intellisense
3. Processing of delimited strings
4. Compression.
5. Resource governor
6. Plan freezing
7. C like math syntax
8. Auditing.
9. Inline variable assignment.