Results 1 to 2 of 2

Thread: 8k row limit on sql server

  1. Sep 26th, 2016, 05:03 AM #1
    venerable bede
    venerable bede is offline

    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
    Reply With Quote Reply With Quote
  2. Sep 26th, 2016, 07:51 AM #2
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width