>After having changed a field from a Text type to a NVarChar(Max) type, the size of the MDF has increased by three times. I am not sure if this is normal or if I should do a compress. Basically, 99% of the MDF is in regards to that field. So, does this make sense?
Yes, I would expect size increase after this switch, since nvarchar takes twice size of text.
If it's not broken, fix it until it is.
My Blog