Load testing - SQLQueryStress

"SQLQueryStress is a free tool that provides a simple means of load testing individual queries. It provides some support for query parameterization and options for collection of I/O and CPU metrics. It is not intended to replace tools such as Visual Studio Team System's load tests, but rather to be a simple and easy-to-use tool in the DBA or database developer's kit. I think it lives up to that goal, and initial feedback I've gotten from a few people I've shown it to has been positive. I've been working on this project on and off for around the last eight months, so I'm quite excited to finally release it to the public!"
(Adam Machanic)

Check out
http://www.datamanipulation.net/SQLQueryStress/

to download the tool.