I have a huge archive table in a lightly used archive database. We really don't need all the data in each row, and I was considering updating a lot of columns to NULL. Will that free up space for reuse, either with or without shrinking the database file ? I don't want to actually drop the unneeded columns because I might break applications that populate & use the table, but I would like to reclaim space.
(SQL 2008 R0, std ed.)