Advertisement
Guest User

Untitled

a guest
Jul 29th, 2014
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SELECT deqs.last_execution_time AS [Time],
  2. dest.TEXT AS [Query]
  3. FROM sys.dm_exec_query_stats AS deqs
  4. CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
  5. ORDER BY deqs.last_execution_time DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement