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