Quick one today:

A few days ago, this script came in handy when a certain thread needed to be cleaned on a lab server.

Sometimes such a command could take a long time depending on the payload of the SPID that we are trying to kill. Sql Server will first try to rollback the SPID, to make sure it brings the session back to a stable point and then kills it. Such rollback sometimes takes a long time. So, to check how far along it has progresses, this below script comes in handy.

KILL With StatusONLY