Gudday!

These days I´m doing a lot of low-level performance testing and sooner or later you always end up checking your code performance against the database performance and this time I was chasing milliseconds. So, here I am with some SQL wanting to check exactly how much time it takes to execute. You might´ve noticed that the SQL Server Management Studio only displays full seconds in execution time? Well, you may measure it in milliseconds as well, just use the SET STATISTICS flag to activate:

SET STATISTICS TIME ON

SELECT * FROM myTable

SET STATISTICS TIME OFF
Why not join the newsletter?

Why not join the newsletter?

If you're not a fan of facebook or twitter, sign up to the newsletter and I'll send you a quick update every so often with what's going on and new posts coming out.

You have Successfully Subscribed!