select TOP 50
sqlText.text,
queryStats.last_execution_time,
queryStats.creation_time,
queryStats.execution_count,
queryStats.total_elapsed_time
from sys.dm_exec_query_stats as queryStats
cross apply sys.dm_exec_sql_text(queryStats.plan_handle) as sqlText
order by queryStats.last_execution_time desc;