MSSQL: cached query plans

gistfile1.sql

-- DO NOT RUN this script on Production environment
-- Clear the plan cache
dbcc freeproccache

-- Look at the cached query plans
select st.text,*
from sys.dm_exec_cached_plans cp
cross apply sys.dm_exec_sql_text(cp.plan_handle) st
where (st.text like '%select * from Person.Address%')
and st.text not like '%select st.text%'