MS SQL Server load testing with JMeter and stored procedures

JMeter is a great tool. I have been using it for quite some time for now, but mainly to test web application and web services. Recently I had to perform bunch of load tests on SQL Server, just to check if new one will be faster than old one. It turns one that JMeter is pretty handy when comes to simple SQL load testing.

Query execution time in miliseconds in SQL Server Management Studio

If you need to get query execution time in milliseconds in SQL Server Management Studio, there is a simple way to achieve this.

Returning rows in random order from MS SQL Server

Have you ever needed to return rows from MS SQL Server in random order every time you execute query? Here is simple solution to achieve this.

select top 10 * from some_table order by newid();