Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N):
Performance comparison of varchar(max) vs. varchar(N)
Views – 2098
Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N):
Performance comparison of varchar(max) vs. varchar(N)
Views – 2098