This script returns index usage stats along with drop and create DDL.
2017-05-16 (first published: 2017-05-05)
Identifies SQL and or Jobs that are using tempdb space.
2016-10-07 (first published: 2016-09-20)
Provides sp_who data plus a connection summary and lead blocker details.
2015-10-21 (first published: 2013-12-26)
Determine when a Stored Procedure was created and last altered.
2015-02-25 (first published: 2013-12-26)
Generate script to drop any unwanted user created statistics.
2015-02-24 (first published: 2013-12-26)
This SQL script will return basic information on each database on your server.
2014-01-21 (first published: 2013-12-28)
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
Dynamically generate trigger DDL and write to individual SQL files.
2013-12-02 (first published: 2013-11-18)