Search
Active

13
Sign in to vote
0
Sign in to vote
Sign in
to vote
Type: Suggestion
ID: 497345
Opened: 10/12/2009 7:12:53 AM
Access Restriction: Public
1
Workaround(s)
It would very informative to have an endtime of when the query execution completed next to the duration of the query in SQL Server Management Studio.

One example,
You execute a long running query, leave the window and comeback "later". You can see that the query completed in "00:10:00" but not what time it actually ended so that you can send an accurate email saying "all the records have been updated as of time X"
This would help in the case that you execute a long running query and come back to it later seeing that it finished in "00:10:00" but not knowing when it actually finished.

Another example,
Say you are running a purge query in one query window and a SELECT COUNT(*) in another query to see how many more records need to be purged. You leave that window and come back to it "later", well you know how many records were left from the last SELECT COUNT(*) but you don't know what time that was executed and therefore when you rerun your query and get the new count of how many records are left you can calcuate how many records were purged since "earlier" but not how long it took to purge them since you didn't have a timestamp of from "earlier".
Details (expand)
Product Language
English

Category

Tools (SSMS, Agent, Profiler, etc.)
Proposed Solution
Add an endtime of when the query execution completed next to the duration of the query in SQL Server Management Studio.
Benefits
Other (please provides details below)
Other Benefits
Makes adhoc queries more informative
File Attachments
0 attachments
Sign in to post a comment.
Posted by Nagy_Sr on 10/12/2009 at 7:19 AM
Would be very useful.
Posted by MLauer07 on 10/12/2009 at 7:24 AM
This would be good to have
Posted by Jeff Hu on 10/14/2009 at 8:34 AM
Very useful and smart idea