Your SPID shows KILLED/ROLLBACK and never seems to finish. Here is what that state means, why SQL Server sometimes cannot undo the work and what to do next.
SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed
While building an AlwaysOn demo I hit the Database Mirroring login attempt failed error with a connection handshake failure. Here is how I fixed it.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
Login failed for user. Reason: Token-based server access validation failed. Here is how the state of error 18456 in the ERRORLOG shows the cause and fix.
Bring SQL Cluster Resource Online When It Sits in Online Pending
A client could start a SQL Server instance from services.msc but could not bring SQL cluster resource online in Failover Cluster Manager. Here is how I checked the connection and found the cause: a TCP alias with an old port.
SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol
Doing the basics right matters. Here is a simple, story-driven explanation of the Write Ahead Logging (WAL) protocol that keeps SQL Server transactions safe.
ADD FILE in an Availability Group: What Happens on the Secondary Replica
ADD FILE on the primary of an availability group reaches every secondary as a log record. If the same path doesn’t exist on a secondary, the operation fails and data movement is suspended. Here is how to resume it.