Get adhoc query plans without reuse

SELECT 
	cp.usecounts, text querytext, cp.size_in_bytes/1024 size, plan_handle
FROM sys.dm_exec_cached_plans AS cp
	 CROSS APPLY sys.dm_exec_sql_text(plan_handle)
WHERE cp.cacheobjtype = N'Compiled Plan' AND 
	  cp.objtype = N'Adhoc' AND 
	  cp.usecounts = 1
ORDER BY querytext
GO