you could run into problems with inserting/updating rows with unecessarily oversized rows of data;
SQL still has a max row size of 8060, so if you had an update statement that tried to manipulate too many oversized columns, you'll get an error.
Warning: The table XXX has been created, but its maximum row size exceeds the allowed maximum of 8060 bytes.
-- INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit.
Lowell