8k row limit on sql server
Hi all
I need to add a new field to a table in sql server 2012 which needs to be 6000 chars but which may expand in the near future.
I was thinking on making this a VARCHAR(Max) but am worried what will happen if it exceeds the 8k page limit.
Am I right to be concerned?
What should I take into consideration?
TIA
Re: 8k row limit on sql server
What happens is a row split. The data is stored off the row in another data page. Your queries are a bit slower (you need to access multiple non contigious pages) but that should be all