Find single-use, ad-hoc, and prepared queries
dm_exec_cached_plans , dm_exec_sql_text
dm_exec_cached_plans , dm_exec_sql_text
File names and paths for all user and system databases on instance master_files
Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column. suspect_pages