SQL Server 2008 New Data Types

At a Glance:

• New date and time data types
• Representing position in a hierarchy
• Two models for working with spatial data

http://technet.microsoft.com/en-us/magazine/cc434692(TechNet.10).aspx