Post reply

Max size of each row in a table.

  • October 17, 2009 at 3:52 am

    #212397

    What is the max size of one row of a table?

    Can anybody please respond to me?

    Thanks.

  • October 17, 2009 at 4:16 am

    #1067313

    Sourav-657741 (10/17/2009)

    What is the max size of one row of a table?

    8060 bytes, excluding LOB data and not considering row versioning or other things that will reduce the available space on a page.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 17, 2009 at 5:17 am

    #1067316

    8060 bytes is the maximum one row can consume on the top-level data page.

    More than 8060 bytes of data can be stored in a row, either by using true LOB types like XML, the MAX types, or the older (and deprecated) text, ntext, and image types.

    More than 8060 bytes of data can also be stored on 2005 and later by using the ability of certain variable-length data types to overflow on to ROW_OVERFLOW_DATA allocation units. Some people regard these as a type of LOB :blink:. You can define over 300 VARCHAR(8000) columns on a row for example - and fill them too. Not recommended!

    Paul

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply