Date is one of the most requested data types and finally MS implemented it in SQL Server 2008 and i love it. The new datatypes are just one of the greate improvements in SQL Server 2008!
If you havent upgraded yet I will give you some arguments:
🙂 Data compression, I shrinked one of our database with 75%, without performance loss (4 x Quad processor can handle the increased CPU usage.
🙂 Filtered indexes, I added more (covering) indexes to improve read performance in some of the queries without any or very little loss of write performance.
🙂 User defined Table type, and the possibility to pass the table between stored procedurs ( instead of temporary tables )
🙂 Multiple value inserts within a single INSERT statement
This is just a subset of new features that i already have implemented and i think makes it worth the effort to consider upgrading.
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform