SQL Server 2008 R2: Unlock the Locks

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem that seems like something else that can make troubleshooting all the more difficult and frustrating. Other times, the answer you’re looking for is staring you right in the face. This is the case with SQL Server 2008 R2, which has a known locking issue you can resolve by simply applying the latest service pack or update. Continue reading “SQL Server 2008 R2: Unlock the Locks”