Yesterday, I received a question about the difference between nvarchar(n) and nvarchar(max). Why don't we always use nvarchar(max)? Are nvarchar(n) and nvarchar(max) different in performance ? Are nvarchar(n) and nvarchar(max) different in storage size ? First of all, What is nvarchar(n)? nvarchar [ ( n | max ) ] Variable-length Unicode string data. n defines the string … Continue reading nvarchar(n) vs nvarchar(max) performance in MS-SQL Server