Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2012-07-12 (first published: 2007-10-30)

3,020 reads

Blogs

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Say you need outside help. You’ve exhausted all the things that you could do...

I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...

Forums

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Comments posted to this topic are about the item BIT_COUNT() III

Comments posted to this topic are about the item The Mythical Bus Accident

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?