Session
Blocking: How to Find and Fight LCK* Waits
When you’re facing lock waits and blocked queries, it’s tempting to just slather NOLOCK all over the queries. Thing is, this won’t necessarily fix it, and there are much better ways to track, diagnose, and cure blocking issues. You’ll learn them here.

Brent Ozar
I make Microsoft SQL Server go faster.
Las Vegas, Nevada, United States