NVarchar (MAX) for short strings

Question

I am interested in the fact that NVarchar (MAX) is a good data type. I want to store short unicode strings 1-50 characters long, but most of them (over 90%) are 5-10 characters long?

The column will not be used to compare and organize queries. It can be added to the index as an included column. The number of expected rows is more than 10 M.

Any recommendations? Thank you in advance!

Answer 1

Why are you using nvarchar (MAX) for such short lines? If you know that the maximum length is 50 characters, make it nvarchar (50).

, , nvarchar (MAX) , 900 .

Answer 2

, nvarchar (50) , 50.

Answer 3

NVARCHAR (MAX) (which I assume is the same as NTEXT in earlier versions of SQL Server) is designed to store long text values ​​of a variable and potentially unlimited length.

If you know that the values ​​will not exceed N characters, you should use NVARCHAR (N).