Question: why nvarchar max is bad?
Answer: However, index key length allowed is 900 bytes. Thus any nvarchar column which will exceed this value will cause issue and will be failed. estimates more memory grant and this value will be much higher than actual required and this would be a waste of a resource as precisous as memory.