My Sql Server 2008 Feature :

1. Both are combined as SSMS (Sql Server management Studio).

2. XML datatype is used.

3. We can create 2(POW (20))-1 databases.

4. Exception Handling

5. Varchar(Max) data type

6. DDL Triggers

7. DataBase Mirroring

8. RowNumber function for paging

9. Table fragmentation

10. Full Text Search

11. Bulk Copy Update

12. Can encrypt the entire database introduced in 2008.

13. Can compress tables and indexes.

14. Date and time are separately used for date and time datatype, geospatial and timestamp with internal time zone is used.

15. Varchar (max) and varbinary (max) is used.

16. Table datatype introduced.

17. SSIS avails in this version.

18. Central Management Server (CMS) is Introduced.

19. Policy based management (PBM) server is introduced.