theuntitled/Measure.sql

Created February 27, 2019 09:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/theuntitled/0ed5fcb170334f1c9a78ead386027e7a.js"></script>
Save theuntitled/0ed5fcb170334f1c9a78ead386027e7a to your computer and use it in GitHub Desktop.

Download ZIP

Measures the elapsed time for a query in milliseconds.

Raw

Measure.sql

	DECLARE @t1 DATETIME;
	DECLARE @t2 DATETIME;

	SET @t1 = GETDATE();

	-- Query to measure

	SET @t2 = GETDATE();
	SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment