Assume we have a really big table in SQL Server with millions of rows. There is a text column that can contain quite long character strings (limited to say 4000 characters of length), but the column is nullable since there are many rows in the table where no text is put in that particular column at all.
From the point of view of storage and especially performance:
Is it better to use the NVARCHAR(MAX) type or the NVARCHAR(4000) type?