Skip to content
View mikejwhitty's full-sized avatar
5 followers · 1 following
  • United Kingdom

Achievements

Achievement: YOLOAchievement: Arctic Code Vault ContributorAchievement: Pull Sharkx3

Achievements

Achievement: YOLOAchievement: Arctic Code Vault ContributorAchievement: Pull Sharkx3

Block or report mikejwhitty

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

Pinned Loading

  1. list currently running requests on m... list currently running requests on ms-sql server, for help identifying long-running or probematic queries
    1 
    USE [master];
    2 
    
              
    
              
    
                3
                
    SELECT r.session_id, 
    
              
    
              
    
                4
                
        ms_running = DATEDIFF(ms, r.start_time, GETDATE()),
    
              
    
              
    
                5
                
        db = db_name(r.database_id), --schema = object_schema_name(t.objectid, r.database_id),
    
              
    
          
    
    
    
  
    

    2.