Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave62 What's the best way to count? RE: What's the best way to count?

  • October 19, 2010 at 9:31 am

    #1239132

    Here is the execution resuls of the 1-st and 4-th query:

    --Query 1

    SQL Server Execution Times:

    CPU time = 0 ms, elapsed time = 76 ms.

    --Query 4

    SQL Server Execution Times:

    CPU time = 0 ms, elapsed time = 0 ms

    SQL Server parse and compile time:

    CPU time = 0 ms, elapsed time = 142 ms.

    So the Query #1 was faster.