Post reply

Regarding row size

  • September 11, 2012 at 2:49 am

    #281427

    Hello Masters,

    As per "Maximum Capacity Specifications for SQL Server" (for details "http://msdn.microsoft.com/en-us/library/ms143432.aspx") Bytes per row8 is "8060".

    That means each row will be of 8 KB, than what will happen if row lengh is more than 8060 bytes (OR 8 KB)? Will it be continue in another row ? will it use another row? My question is what will happen when the length of the row is more than maximum capacity of sql server ?

    Thanks in advance,

    Jitendra

  • September 11, 2012 at 4:06 am

    #1536108

    Googling it out would give you the answer quite easily:

    http://msdn.microsoft.com/en-us/library/ms186981(v=sql.105).aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • September 11, 2012 at 4:14 am

    #1536112

    jitendra.padhiyar (9/11/2012)

    My question is what will happen when the length of the row is more than maximum capacity of sql server?

    If the row is comprised of fixed-length data types, you'll get an error creating the table. If there are variable-length,they overflow onto LOB pages (much as Varchar(max) and the other max data types are handled).

    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

  • September 11, 2012 at 4:19 am

    #1536117

    Thanks a lot Gilamonster,

    the size of the normal page is 8 KB, what is be the size of LOB pages ? Is it chain of normal pages ?

    and my second question is

    Can one row be written(expand) on two pages ?

    Thanks in advance,

    Jitendra

  • September 11, 2012 at 4:21 am

    #1536121

    jitendra.padhiyar (9/11/2012)

    the size of the normal page is 8 KB, what is be the size of LOB pages ?

    8k. All pages without exception are 8k

    Can one row be written(expand) on two pages ?

    Other than via the row overflow or LOB data types, no.

    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

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

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