Query for returning query plans from sql plan cache that contain 1 or more warnings? Is there a query I can run to return query plans from sql plan cache that contain 1 or more warnings?
RedGate has a great article Checking the Plan Cache Warnings for a SQL Server Database on how to query the plan cache to find plans with warnings.
Ultimately the warnings will be stored in the XML query_plan column of sys.dm_exec_query_plan DMV.