STATISTICS IO
and STATISTICS TIME
show the amount of time spent on a query and the reads and writes of the query in question. This is good to know for quick performance testing.
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
SELECT COLUMNLIST FROM TABLE
SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;
Visit the DevX Tip Bank