Find the most executed stored procedure(s).
2015-05-01 (first published: 2013-08-13)
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
Query to list all running SQL jobs.
2011-09-15 (first published: 2011-09-05)
Display %complete SQL using SYS.DM_EXEC_REQUESTS
2011-08-05 (first published: 2011-07-23)
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)