THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » dates   (RSS)
  • 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 articleFor example, the plan for the following query performs an index seek on the index on the CurrencyRateDate DATETIME column: USE AdventureWorks; SELECT ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 24, 2008
  • 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,DATEADD(ms,1,@t) AS TimeMilli, DATEADD(ns,10000,@t) AS TimeNano1,DATEADD(ns,100,@t) AS ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on August 1, 2007
Privacy Statement