Select the recent queries on the server

SELECT deqs.last_execution_time AS [Time],

dest.TEXT AS [Query],

decp.query_plan

FROM sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

CROSS APPLY sys.dm_exec_query_plan(deqs.plan_handle) AS decp

ORDER BY deqs.last_execution_time DESC

Note: This select returns only queries from the memory cache.