[dba-SQLServer] SQL Server 2008: New data types

Gustav Brock Gustav at cactus.dk
Wed May 28 04:23:33 CDT 2008


Hi all

Noticed this article about the new data types of SQL Server 2008 for date/time, hierarchy, and spatial (geometry and geography):

  http://technet.microsoft.com/en-us/magazine/cc434692.aspx 

It seems as if the old US date/time format is left in favour of the ISO 8601 format. That alone is a progress.
And time precision is now down to 100ns - well beyond the previous 3.33 ms and the 1ms of JET.

/gustav





More information about the dba-SQLServer mailing list