Archive:
Search site:
Tags:
Blocking (1) Concurrency (2) Execution Plans (4) GETDATE (1) Indexes (1) internals (10) linux (1) Optimization (4) Performance (7) Performance Tuning (2) pgadmin (1) postgres (1) RCSI (2) Schemas (1) Security (1) SQL Server (15) Statistics (1) Triggers (1) tsql2sday (1) Version Store (2)
Categories:
Month: July 2026
-
This post is my first T-SQL Tuesday post since starting the blog a couple of months back. T-SQL Tuesday was originally set up by Adam Machanic, original creator of the essential sp_whoisactive stored procedure. The concept is that once a month, a different host puts out an invitation to the community for bloggers to write…
-
Last Updated: July 7, 2026 In SQL Server, there are a few DMVs that tell us “What is running now”. This is built into SSMS as Activity Monitor, but I’ve never met anyone who actually finds that method useful, there’s also sp_who and sp_who2, but they are dated and limited in what they tell you.…