Happy to help:
SELECT readily_available_info
FROM BooksOnline AS MyPrimaryReferenceBook
WHERE contents_title = 'cascading referential integrity constraints'
OR index_title = 'ON DELETE clauses'
(1 row(s) affected)
Table 'BOL'. Scan count 0, logical reads 3, physical reads 1, read-ahead reads 0.
Table 'MSDN'. Scan count 0, logical reads 7, physical reads 7, read-ahead reads 0.
Table 'UserGoogleSearch'. Scan count 0, logical reads 0, physical reads 0.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 1 ms.
SQL Server Execution Times:
CPU time = 1 ms, elapsed time = 3 ms.
[/font]
Sometimes it is faster to look it up for yourself rather than to ask for teh codez.
http://msdn.microsoft.com/en-us/library/ms186973(SQL.90).aspx
and a more generally useful resource:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi