Row and Page Compression Facts

Question

Post reply

Row and Page Compression Facts

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
September 10, 2021 at 12:00 am

#3918220

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

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

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

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 1

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!

kaspencer SSCarpal Tunnel Points: 4880 More actions · Answer 2

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

JKB Ten Centuries Points: 1135 More actions · Answer 3

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

alex.valen SSC Eights! Points: 940 More actions · Answer 4

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

jk.capoeira Valued Member Points: 60 More actions · Answer 5

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.