Skip to content

Instantly share code, notes, and snippets.

@Elnee

Elnee/query_history.sql

Created January 11, 2020 11:15
Show Gist options
  • Save Elnee/f6881ee1d103babf8da2ae441d2a162c to your computer and use it in GitHub Desktop.
Save Elnee/f6881ee1d103babf8da2ae441d2a162c to your computer and use it in GitHub Desktop.
Download ZIP
Query history for MS SQL
Raw
query_history.sql
SELECT deqs.last_execution_time, dest.text
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.text LIKE N'%<table_name>%'
AND deqs.last_execution_time >= '2020-01-01 00:00:00.000'
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