i have 1 TB of database, one of the table has a column type "Image, null"

currently this column is holding plunty of binary data, 

if i update this this column with null would it free up lot of space on db, after shrink obviously.

R

Hello,

And what's the question here; I don't see one?

question is would updating each column with NULL value free up lot of space? which is image type, 

or it wont make a big difference?

my plan is  instead of purging the entire old records i am planning to change the values of one major column from

0x504B0304140000000800939D6D386CEF9AA92

7E10000657801000E00000052756C614B686F75

72792E786D6CDC3BD972EA4A92CFDD11FD0F35

27626266E21C1B241603C3E5464908908D1020

to NULL?

Hi K,

Since this issue is related to Transact-SQL, I will move this thread to Transact-SQL forum. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Regards,
Katherine Xiong

Go ahead to restore your database in a test environment and try your update and shrink your database files. 

question is would updating each column with NULL value free up lot of space?

Sure it will, depending on the amount of existing data.