title: NVARCHAR(MAX) to replace TEXT datatype?
body: <p>I have read about <a href="https://stackoverflow.com/questions/148398/are-there-any-disadvantages-to-always-using-nvarcharmax">Are there any disadvantages to always using nvarchar(MAX)</a> and <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4d9c6504-496e-45ba-a7a3-ed5bed731fcc/varcharmax-vs-varchar255?forum=sqlgetstarted" rel="nofollow noreferrer">varchar(max) vs varchar(255)</a> from different forums. Now, I wonder if it is <em>ideal/safe</em> practice to convert a <code>text</code> datatype to <code>nvarchar(MAX)</code>? Are there any performance difference? or do I need to specify the size (as in<code>nvarchar(255)</code>) instead of <code>nvarchar(max)</code>?</p>