kill-spid-command-in-sql-server 
SQL Shack
AUGUST 21, 2019
This article gives an overview of the KILL SPID command and how to monitor the rollback progress. Introduction Once we connect to a SQL Server instance, it assigns a unique identification number to each connection. It is the Server Process ID and commonly known as SPID.
SQL Performance
FEBRUARY 22, 2021
I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The official documentation for sys.sysprocesses warns: This SQL Server 2000 system table is included as a view for backward compatibility. But habits are hard to break; ask me how I know.
Expert insights. Personalized for you.
50 
Let's personalize your content