GitHub

AdalbertKing/mssql-windows-scripts-for-multiple-backup-and-restore-all-databases

A package of .BAT scripts and .sql queries for MSSQL for Windows to perform an automatic backup of all working databases on MSSQL ended with generating the SQL query needed to restore this backup. The ...
GitHub

Show.Running.Queries.in.Database.sql

CROSS APPLY sys.dm_exec_sql_text(r.[sql_handle]) t OUTER APPLY sys.dm_exec_query_plan(r.plan_handle) p --OUTER APPLY sys.dm_exec_text_query_plan(r.plan_handle, r ...