SELECTqs.creation_time,qs.last_execution_time,qs.execution_count,qt.text AS sql_text,qp.query_planFROMsys.dm_exec_query_stats AS qsCROSS APPLYsys.dm_exec_sql_text(qs.sql_handle) AS qtCROSS APPLYsys.dm_exec_query_plan(qs.plan_handle) AS qpORDER BYqs.last_execution_time DESC;...