Row and Page Compression Facts

  • Comments posted to this topic are about the item Row and Page Compression Facts

  • From your link:

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

    So, the "Compression can allow more rows to be stored on a page" is true!

  • I fell on that point too!

     

    You never know: reading my book: "All about your computer" might just tell you something you never knew!
    lulu.com/kaspencer

  • Agh! I chose the two true answers...note to self, READ the question carefully before answering!

  • And from the same page: Off-row data is not compressed when enabling data compression, so that one is true and therefor false as an answer to this question

  • I think there was a typo mistake in the question and the word 'not' was missing.  Option 2 was he "Compression allows more rows to be stored on a page" which is true, but in the explanation it says he "Compression does not allow more rows to be stored on a page" which is false.

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

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