There are many commercial tools to help you design and test SQL statements, as well as the execution tests in built into SQL Management Studio – however sometimes you just need to run a simple test to measure and compare different statements.
This is where the SQLQueryStress tool comes in handy.
You connect the tool to your SQL database, copy in your query and tell it how many times you want to run through the test. Once the query has been processed the statistics are shown in the same window.
It can be downloaded from the developers website here: http://www.sqlstress.com/
UPDATE: it looks like the developers website is no longer functional. Until it is, here is an alternative download: https://www.itsupportguides.com/downloads/SQLQueryStress.exe