>SET STATISTICS TIME ON
>
>This will cause SQL server to display time stats for each sql statement.
>
>
Thanks, Eric. How can I repeat same statements multiple times? I assume, I can set output to be a file, right?

Here are my results, can you add some comments at what exactly should I look while analyzing them (I'm currently running them on my local machine):

(I ran 3 quite simple count SQL from one flat table)


==============================================
SQL Server Execution Times:
CPU time = 23 ms, elapsed time = 23 ms.
ResultCount
-----------
1

(1 row(s) affected)


SQL Server Execution Times:
CPU time = 50 ms, elapsed time = 2663 ms.
ResultCount
-----------
41

(1 row(s) affected)


SQL Server Execution Times:
CPU time = 70 ms, elapsed time = 388 ms.
ResultCount
-----------
38

(1 row(s) affected)


SQL Server Execution Times:
CPU time = 21 ms, elapsed time = 387 ms.