===== DateDiff/DateAdd method ======

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

653 Milliseconds

===== DateDiff/DateAdd method...

Accuracy test...

--===== Create a test table

CREATE

TABLE dbo.BigTest2

(

RowNum

INT NOT...

Rounding method 2 has a desing flaw for all dates.

SELECT

DATEDIFF(DAY, 0, '20070708...

Replace TOP 100 with TOP 1.

SQL Server 2008 Developer Edition

1 GB RAM (SQL Server service 256 MB)

Fujitsu Siemens E8020 LifeBook Laptop Pentium-M 2GHz

SELECT TOP 100 LastName, FirstName

FROM (

SELECT LastName.LastName,

FirstName.FirstName

FROM Table1 AS LastName

CROSS JOIN Table1 AS FirstName

WHERE LastName.Gender = 'M' AND FirstName.Gender = 'M'

UNION ALL

SELECT LastName.LastName,

FirstName.FirstName

FROM Table1 AS LastName

CROSS JOIN Table1 AS FirstName

WHERE LastName.Gender =...

This has one caveat as MVJ has pointed out. It does not work for 1753-01-01

PRINT '===== Minus method ====='

   DBCC DROPCLEANBUFFERS

   DBCC FREEPROCCACHE

    SET @StartTime = GETDATE()

 SELECT @MyDate=CAST(Adate - 0.50000004 as...

I realized that too, but sincce neither 2006 nor 2007 are leapyears it works.

CREATE TABLE #LatLong (Latitude DECIMAL, Longitude DECIMAL, PRIMARY