I have a database table, sql server 2016, that is where we will save our dynamic content.
since they are varchar, does it really matter if they are empty or full? if empty they won't take up anymore space than if it weren't in the table at all will it?
Reason I ask is, the nvarcchar(max) won't be used as often as the others, and I thought about putting it in a separate table with a relation. But if having it in there empty doesn't add any extra space, I'd prefer doing that.