Transact-SQL scripts


Disclaimer: use at your own risk, and always test before running on production.

  • Dynamic PIVOT statement (link)
  • MSDB job history converted to datetime (link)
  • Running processes including job name and job step (link)
  • Slow delete, based on number of days to delete (link)