Geek asks and answers

Where did I find the milliseconds to execute a query in SQL Server 2008 Management Studio?

Where did I find out the milliseconds to execute a query in SQL Server 2008 Management Studio?

In the actual execution plan, I do not see the time.

+5
source share
3 answers

use the ON / OFF TIME STATISTICS SETTING at the beginning and end of the query

+9
source

A few places:

+1
source 
 CultureInfo newCulture = (CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
 newCulture.DateTimeFormat.ShortDatePattern = "MM-dd-yyyy";
 newCulture.DateTimeFormat.DateSeparator = "-";
 Thread.CurrentThread.CurrentCulture = newCulture;
-1

More articles:


All Articles