Buddies,

I am using SS2005 and I ran the first query: DECLARE @TimeStart DATETIME

DECLARE @Time DATETIME

DECLARE @TimeEnd DATETIME

DECLARE @I INT

DECLARE @Count INT

SET @I = 0

SET @Count = 0

SET @TimeStart = GETDATE()

SET @Time = @TimeStart

WHILE @I < 10000000

BEGIN

SET @TimeEnd = GETDATE()

IF @TimeEnd <> @Time

BEGIN

SET @Count = @Count + 1

SET @Time = @TimeEnd

END

SET @I = @I + 1

END

PRINT @Count

PRINT DATEDIFF(millisecond, @TimeStart, @TimeEnd) / CAST(@Count AS REAL)

I have got the values: 6519 and 3.33379.

I ran the same query again to re-verify, but I have got: 6518 and 3.3363.

The precision is 3.33 for GETDATE() function.

How these values are vary (595 and 15.6521 - 6519 and 3.33379) ?