Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...
When we encountered excessive blocking issues with reports, one tempting solution was to use the WITH NOLOCK table hint to get the report running smoothly and avoid blocking behavior completely.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback