Posts

Showing posts from September, 2013

SQL Query Execution time of you in SQL Management Studio

Image
You can check the Execution time of you SQL Query in SQL Management Studio. like this


It is very simple that you just put your SQL Query in to the Estimated time execution query


DECLARE @StartTime datetime DECLARE @EndTime datetime SELECT @StartTime=GETDATE() -- Write Your Query SELECT @EndTime=GETDATE() --This will return execution time of your query SELECT DATEDIFF(NS,@StartTime,@EndTime) AS [Duration in millisecs]