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.