Wednesday, November 8, 2006 11:17 PM
rusanu.com
Fast way to check message count
A fast way to check the count of messages in a queue is to run this query is to look at the row count of the underlying the b-tree that stores the messages:
select p.rows from sys.objects as o join sys.partitions as p on p.object_id [...]
Read More...