Be sure to get the latest version of this script from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox Have you ever wanted a quick and easy way to see who was holding (and waiting on) locks on a particular database? Perhaps you've got some blocking issues going on and you want to see exactly which rows the row level... Continue Reading →
Intent Locks In SQL Server
Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They're something that I've found myself explaining time and time again, I've even been on calls with customer DBAs who don't fully understand why they're there and what they're doing. So what exactly is an intent lock and why... Continue Reading →
Using Indexing To Solve Blocking and Deadlocking Issues
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help solve it. The reaction I got was along the lines of, 'What, how can in index solve a deadlocking issue?' So, can we solve a deadlocking issue with an index? Let's create a rather simple,... Continue Reading →