Hi,

I have a huge table in my database:

column datatype
x int
y text

And I did this:
update table x
set y = NULL

and if I do sp_spaceused, I see that the unused space for that table has increased. I need to reclaim that unused space. Shrink database and shrink file didn't give the space back.

Can someone help please?
Thanks,
Meera