jcb (1/31/2012)
I need to ask...Changing the column from varchar(245) to varchar(max) is an option?
VARCHAR(something <= 8000) would be better. MAX types prevent online index builds (before SQL Server 2012 is released anyway) and typing the column as a potential LOB has all sorts of other query plan side-effects.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi