The query seems to have gone bad again on my machine with or without a capital ‘C’

I found a way to target and delete specific query plans, but it still is running slow from within .net.

I am trying to find out why it is slow sometimes and fast at other times, any help would be greatly appreciated.

Here is what I found

Find cached plans

SELECT plan_handle, st.text

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

WHERE text LIKE N'%wa.id = cwl.WebAddressID%'

Remove specific plan

DBCC FREEPROCCACHE (0x06001E00AC6A672F90961F6C0400000001000000000000000000000000000000000000000000000000000000