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