SELECT dest.TEXT AS [Query],deqs.execution_count [Count],deqs.last_execution_time AS [Time]FROM sys.dm_exec_query_stats AS deqsCROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS destORDER BY deqs.last_execution_time DESC