Should I use (max) size for all my nvarchar/varchar columns?

· by · in , ,

Should you use VARCHAR(MAX) for all your string columns? No. Here’s why MAX costs you indexing, memory grants, and storage efficiency with demos you can run yourself.