SharePoint Dragons

Nikander & Margriet on SharePoint

Monthly Archives: June 2014

Wiki World Cup

Trying to follow the success of the Dutch soccer team, Margriet’s latest TechNet Wiki blog post proposes a new team line-up:

Kill table lock

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!