IK
nextval('sequence_1')
Size: a a a
IK
Дt
Дt
Дt
Дt
IK
Дt
Дt
IK
MC
select top 100 ca_plan.query_plan
, ca_plan.query_plan.query('declare namespace AMWI = "http://schemas.microsoft.com/sqlserver/2004/07/showplan";
//AMWI:*/AMWI:BatchSequence/AMWI:Batch/AMWI:Statements/AMWI:StmtSimple')
, ca_plan.query_plan.query('declare namespace AMWI = "http://schemas.microsoft.com/sqlserver/2004/07/showplan";
for $i in //AMWI:*/AMWI:BatchSequence/AMWI:Batch/AMWI:Statements/AMWI:StmtSimple
return data($i/@StatementText)
')
, cp.plan_handle
from sys.dm_exec_cached_plans as cp
cross apply (select * from sys.dm_exec_query_plan(cp.plan_handle)) as ca_plan
where cp.plan_handle not in (select plan_handle from sys.dm_exec_procedure_stats)
and ca_plan.query_plan.exist('declare namespace AMWI = "http://schemas.microsoft.com/sqlserver/2004/07/showplan";
//AMWI:*/AMWI:BatchSequence/AMWI:Batch/AMWI:Statements/AMWI:StmtSimple[contains(lower-case(@StatementText), "vg_field_values")
and contains(lower-case(@StatementText), "36")
and contains(lower-case(@StatementText), "38")
and contains(lower-case(@StatementText), "39")
]')
= cast(1 as bit)
MC
MC
Дt
Дt
Дt