Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alaawahbah/b1bde015b4d06f698ce0896138e9d6c2 to your computer and use it in GitHub Desktop.
Save alaawahbah/b1bde015b4d06f698ce0896138e9d6c2 to your computer and use it in GitHub Desktop.
SELECT deqs.last_execution_time AS [Time],
dest.text AS [Query],
dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
--WHERE dest.dbid = DB_ID('msdb')
where dest.text like '%delete %'
ORDER BY deqs.last_execution_time DESC
--SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
--FROM sys.dm_exec_query_stats AS deqs
--CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
--WHERE dest.dbid = DB_ID('msdb')
--ORDER BY deqs.last_execution_time DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment