Thanks in advance for your help.
I have a 5TB database with mutliple filegroups. The primary filegroup has one file, the .mdf and which is about 2.5TB. About 700GB of the space in the primary FG is made up of a single table which contains LOBs (Varbinar(max) column). After copying the table to a new filegroup and dropping the table in the primary FG, I see the "unused space" in the primary FG increase as expected.
Because I have freed such a large chunk of space and the 2.5TB file is close to the capacity of the drive it resides on, I am tempted to shrink the file to 2TB or so. Two question:
1.) If I don't shrink the file, will the unused LOB space be reused?
2.) When shrinking the file, I see a lot of LOBCompaction operations happening, but I don't think there are many LOBs left in the database. Does the shrink operation still have to do work on LOBs from a table which has been dropped?