Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

(Kenneth Fisher) I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I have a blocking situation I like to look and see what query is running that is blocking everything else.

Read More - Register for Free Membership