ALZDBA (10/26/2010)
Did you have a look at http://www.sqlservercentral.com/Forums/FindPost1008735.aspx
Yep (linked above), but it didn't seem quite on-target or I misunderstand something:
Considering the above know behavior of SQL , which is by design the work around to release the empty LOB pages is as follows:
Use DBCC CLEANTABLE('databasename', 'tablename') to deallocate all the empty extents.
That advice does not appear to be correct: "DBCC CLEANTABLE" did nothing in this situation...
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.