Imagine this; you have been looking at the new data type DateTime2 in Sql Server 2008 because you have a need for the increased precision this data type offers. Comparison here: "SQL Server 2008 Books Online (October 2008) - datetime2 (Transact-SQL)"
