• SanDroid (11/17/2010)


    Disapointing and Lame trick question.

    The question asked which row had the "largest defined row size", not "the largest storage size".

    Compression can allow more rows to be stored on a page, but does not change the maximum row size of a table or index.

    http://msdn.microsoft.com/en-us/library/cc280449.aspx

    So even though the maximum storage size of the data is less with compression on, the defined maximum row size of the data is not any differant.

    I agree. I got this wrong for the same reason. The Row Size doesn't change, compression just lets more data be stored on a page.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]