For a database administrator , please aware that SQL Server 2008 will now have new datatypes as below are the list.
DATE – ANSI-compliant date data type
TIME – ANSI-compliant time data type with variable precision
DATETIMEOFFSET – timezone aware/preserved datetime
DATETIME2 – like DATETIME, but with variable precision and large date range
GEOMETRY – “flat earth” spatial data type
GEOGRAPHY – “round earth” spatial data type
HIERARCHYID – represents hierarchies using path enumeration model
The first four datatypes are regular SQL datatypes but the last three datatypes are exposed as .NET system UDTs.