one drawback is that varchar(max) can't form part of a index key.

also it's simply wasteful and inefficient.

when you write a program in C, you don't allocate 2gb of memory to hold a 10 character string do you?