I have experienced problems with tables containing LOB_DATA where non of the below statements had any effect in respect of releasing unused LOB_DATA pages.
I have experienced the same problem in a SharePoint _SharedServices1_Search_DB with the stored procedure proc_MSS_GetCrawlHistory. It was running for >120 seconds, 100% cpu on a 4 CPU machine.