Are you SQL Server DBA? Have you ever faced deadlock situations? What are your steps to remove a deadlock? Do you know, how to get the last statement executed by lead blocker transaction? If you are a SQL DBA, you must know about this. You can access few related articles: SQL Server: Database Lock, Deadlock, … Continue reading SQL Server: DBCC INPUTBUFFER to find the last statement executed by a SPID