Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

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