Please note: 9 year old thread.
15. Dates and Times. New data types: Date, Time, Date Time Offset.
16. File Stream. New data type VarBinary(Max) FileStream for managing binary data.
17. Table Value Parameters. The ability to pass an entire table to a stored procedure.
18. Spatial Data. Data type for storing Latitude, Longitude, and GPS entries.
None of these were in SQL 2005, nor were a few others on the list. They were added in 2008
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability