How to free space after I drop a column of a table in SQL Server? [migrated]

The background is that there is a column 'Fn' in a table 'DataProcessed' in SQL Server. Plus, the property of 'Fn' is (varchar(max), NOT NULL).

The problem is that I hope to drop 'Fn' from 'DataProcessed', and free the space which is occupied by 'Fn' in the NDF files of 'DataProcessed'. How can I finish that? Or, is this doable?

Read more here:

Content Attribution

This content was originally published by zyeewang at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: