Browsing the archives for the Tips and Tricks category
One way to find out if a transaction is causing a block is with the sp_who2 system stored procedure. The scope of this procedure is server-wide. It identifies all connections to the database, the login name, the application that is running, and in the context of locks and blocks, any SPIDs that are causing a [...]
I’ve been a SQL Practitioner since 1996 when 6.5 was the hot item. Along the way I’ve learned a bunch of stuff about SQL Server. Without a doubt, the more I learn, the more I know what I don’t know. Being humbled on a regular basis is probably a good thing, but sometimes it’s just [...]