Browse by Tags

• time

• Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008

  I was reading Itzik Ben-Gan's An Introduction to New T-SQL Programmability Features in SQL Server 2008 article yesterday after one of my friends allerted me to the following from that article For example, the plan for the following query performs an index Read More... Posted Thursday, July 24, 2008 3:20 PM by Denis Gobo | 2 Comments Filed under: SQL Server 2008, dates

• SQL Server 2008 Has Nanosecond Precision?

  It looks like SQL Server 2008 has nanosecond precision for the time datatype [edit]I just looked at BOL and yes nanoseconds = ns, microsecond = mcs when used in dateadd[/edit] If you run the following DECLARE @t time SELECT @t = '0:0' SELECT @t AS Time1 Read More... Posted Wednesday, August 01, 2007 12:42 PM by Denis Gobo | 19 Comments Filed under: SQL Server 2008, time, dates