I am trying to understand the varchar(max) data type. I cam across a really old article but it had the exact answers I was looking for. Specifically when do I go from using varchar with some number i.e. varchar(700) to varchar(max)
From This blog post:
I hope, even though this article was from 2006 that this stuff is all still relevant.