Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jacek Osuchowski Do you know your getdate()? RE: Do you know your getdate()?

  • May 12, 2010 at 1:29 am

    #1165990

    I ran the same 2 tests on Win 7 64bit Quad core, 8GB Ram machine running SQL Server 2008 Developer 64bit.

    And got the following:

    GetDate(): 2604 values with precision 3.33333 milliseconds

    SysDateTime(): 13930 values with precision 1000 microseconds, (1 millisecond)

    Judging by the rest of the comments so far it seems to be that XP can't hack it whilst latest OS' can (unless CPU cores played a part).

    However in production you would never use XP, Vista or 7 to run your SQL Server so more interesting would be results on other Windows server versions.