How can i check executing time from mssql2008?
-
I Have complicated sql. (there has many join sql.) so i want to check executing time. How can i check time? Have a nice day.
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
-
I Have complicated sql. (there has many join sql.) so i want to check executing time. How can i check time? Have a nice day.
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
SQL server management studio comes with SQL Query Analyzer[^] which can be used to analyse individual queries.
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
-
I Have complicated sql. (there has many join sql.) so i want to check executing time. How can i check time? Have a nice day.
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
print getdate()
execute yoursp
print getdate()