boca2
Snippet Name: boca2
Tags: helpful,scriptgeneration
Created Date: Oct 1 2021 8:05AM
Last Modified Date: Oct 1 2021 8:05AM
–desc: boca whoisactive capture
Dependencies: none-standalone code
Sample Output:
--desc: boca whoisactive capture
select max([dd hh:mm:ss.mss]) AS [dd hh:mm:ss.mss],count(*) As TheCount,
CONVERT(VARCHAR(max),sql_text),
database_name
from master.dbo.whoisactiveCapture
where database_name =DB_NAME()
-- and convert(varchar(max),sql_text) like '%Enrollment%'
and [dd hh:mm:ss.mss] LIKE '00 00:00:[1-9][0-9].[0-9][0-9][0-9]'
group by CONVERT(VARCHAR(max),sql_text),database_name
order by [dd hh:mm:ss.mss] DESC