Resolving locking issues with SQL Server 2008 R2 can be troublesome -- but it can also be surprisingly straightforward.