Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Adnan Korkmaz,
The output includes the following columns:
You can reset the counters any time by using the following statement:
Last executed query total duration
execute sp_executesql COUNT(*) Output
Current Order Date and Average Count of Orders for Three Prior Days
It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the ol...