dcsimg
Results 1 to 2 of 2

Thread: 8k row limit on sql server

  1. #1

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    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

    Parksie

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,385

    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
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width