Browsing the archives for the Tips and Tricks category
If you learned to play golf by taking lessons the first time the golf pro sets you up to take your first swing it feels awkward. After a while, if you listened to your instructor, your swing becomes more natural, you can stop thinking about every aspect of the swing, you can grip it and [...]
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 [...]