Post reply

Minimum size of a text field

  • February 5, 2004 at 8:35 am

    #84146

    What is the minimum size taken up by a text field when it is empty and when it has 1 character in it?

    Thanks

    MIke


    Michael A. Geles, Jr.

  • February 5, 2004 at 8:50 am

    #492913

    Not sure if I understand you.

    Do you mean the 16 byte root pointer in the data row or the actual size of the b-tree structure that stores the BLOB?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 5, 2004 at 8:52 am

    #492914

    The size of the b-tree storing the blob.

    Mike


    Michael A. Geles, Jr.

  • February 5, 2004 at 2:48 pm

    #492962

    As long as the amount of data you store is less than 32 kb, the text root structure will take 84 bytes. Not sure what happens when no value is inserted. I tend to think that no text root structure is created, or if one exists no additional bytes are consumed. But I'm not certain for the latter case. You should be able to find out by examining the data page.

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

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