What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
13,597 reads
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
13,597 reads
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,499 reads
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
2009-04-24 (first published: 2009-03-27)
1,261 reads
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-12 (first published: 2008-12-31)
2,269 reads
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Hello SSC, I am not sure if I posted this in the right spot,...
What is a partial backup for a read-write database?
See possible answers