• UMG Developer (11/17/2010)


    I couldn't find any definition for "defined row size", do you have a link to a definition? Does it include metadata?

    Exactly my point. The term in the question is "defined row size".

    Not storage row size or maximum row 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

    Also I have noticed that, as has been pointed out by others, the storage concepts in the questions explination may not factual when executed.