Thank you very much for the Article.

Does this also work by Databases that are in the Full Recovery Mode ?

Is there a possibility of Data loss ?

Hello,

first of all thank you very much for your help !

I have checked the expected compression and the data saving is really huge.

Attached are the predicted results first on ROW...

Hello frederico, hello Johan

thank you very much for your help 🙂

if table does not have data_compression = page do you know why that is the case?

-> No data compression...

Hello Johan,

Thanks for your help.

I tried again to create a new column with VARCHAR(max) and to copy the data from the old column to the new column via a loop.

Unfortunately...