SQL性能:使用NVarchar(MAX)而不是NVarchar(200)是否会对性能造成影响?

I am wondering if there is any disadvantage on defining a column of type nvarchar(max) instead of giving it a (smaller) maximum size.I am wondering if there is any disadvantage on