We help IT Professionals succeed at work.

When a field is declare with narchar(max), is this a wast or sapce?

Should I specify a possible range that I know would satisfy for sure with like 100 char.  For instance, someone declare using max for a email field.  Does this waste the space or does it just make it flexible length?  Thanks.
Watch Question

It is flexible length but then the field cannot be indexed.
Top Expert 2012
In general it is considered poor practice not to define explicit sizes.  You should also ask yourself if your really need to support unicode data types.
Imran Javed ZiaConsultant Software Engineer - .NET Architect
It will not waste the space as per varchar space allocation concept definition


Good point, I don't know when I need unicode.  I just always use that .  I'll have to look that up.  You all got great input.  thank you.