Useful SQL Scripts

View query_plan for the just-running query DECLARE @SearchForSql AS NVARCHAR(MAX) = 'Company' SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan FROM sys.dm_exec_cached_plans CROSS APPLY sys.dm_exec_sql_text(plan_handle) CROSS APPLY sys.dm_e...