SELECT  QL.CREATION_TIME
,       QL.LAST_EXECUTION_TIME
,       SQLTXT.TEXT
,       SQLPLAN.TEXT
FROM SYS.DM_EXEC_QUERY_STATS QL
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(QL.SQL_HANDLE) SQLTXT
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(QL.PLAN_HANDLE) SQLPLAN
ORDER BY CREATION_TIME DESC