select dest.text as Query,deqs.last_execution_time
from sys.dm_exec_query_stats as deqs
cross apply sys.dm_exec_sql_text(deqs.sql_handle) as dest
order by deqs.last_execution_time desc
(or)
select dest.text as Query,deqs.last_execution_time
from sys.dm_exec_query_stats as deqs
cross apply sys.dm_exec_sql_text(deqs.sql_handle) as dest
where dest.text like '%dm_exec_query_stats%'
order by deqs.last_execution_time desc
No comments:
Post a Comment