SharePoint Dragons

Trying to follow the success of the Dutch soccer team, Margriet’s latest TechNet Wiki blog post proposes a new team line-up: http://blogs.technet.com/b/wikininjas/archive/2014/06/29/wiki-world-cup.aspx

Found a table that was locked during an ETL process. Retrieved the culprit session via:

select * from sys.dm_exec_requests cross apply sys.dm_exec_sql_text([sql_handle]) where blocking_session_id = 0

Then, killed it like this:

KILL([session id])

And the ETL process is free to try again!