Page compression

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715446

    Comments posted to this topic are about the item Page compression

  • Koen Verbeeck

    SSC Guru

    Points: 258929

    Nice question, but just one small problem:

    "In prefix compression, does the entire prefix stored in the header need to match the data to be used?"

    --> requires the answer NO to be correct

    "In other words, if I have a prefix of "aaabcd" in the header and a data element of "aaabfgr" in a field, can prefix compression be applied?"

    --> requires the answer YES to be correct

    I chose NO, but apparently that was the wrong one, although I meant to answer the first question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • khullargirish02

    SSChasing Mays

    Points: 651

    The answers are different for each line.

    In prefix compression, does the entire prefix stored in the header need to match the data to be used?

    No

    if I have a prefix of "aaabcd" in the header and a data element of "aaabfgr" in a field, can prefix compression be applied?

    Yes..

    I choose No, and it gave incorrect....:hehe:

  • Chris Houghton

    SSCrazy

    Points: 2447

    khullargirish02 (5/27/2011)


    The answers are different for each line.

    In prefix compression, does the entire prefix stored in the header need to match the data to be used?

    No

    if I have a prefix of "aaabcd" in the header and a data element of "aaabfgr" in a field, can prefix compression be applied?

    Yes..

    I choose No, and it gave incorrect....:hehe:

    Same here - I answered the first question as a no.:rolleyes:

  • DugyC

    Hall of Fame

    Points: 3804

    Yep, 2 different questions with 2 different answers.

    Fortunately for me I answered the second question, but I can understand the frustration for those that answered the first.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • TomThomson

    SSC Guru

    Points: 104767

    I answered the second sentence, after reading the whole question (or, rather, both questions ;-)). But I did that with some trepidation, as guessing which of the two questions to answer wasn't a sure thing.

    Very interesting question though. I used to assume that a full match was required and was startled to discover it wasn't (and because I found it startling, I remembered it).

    Tom

  • M&M

    SSC-Insane

    Points: 21679

    Thanks for the question

    M&M

  • gsc_dba

    SSCertifiable

    Points: 5407

    Chris Houghton (5/27/2011)


    khullargirish02 (5/27/2011)


    The answers are different for each line.

    In prefix compression, does the entire prefix stored in the header need to match the data to be used?

    No

    if I have a prefix of "aaabcd" in the header and a data element of "aaabfgr" in a field, can prefix compression be applied?

    Yes..

    I choose No, and it gave incorrect....:hehe:

    Same here - I answered the first question as a no.:rolleyes:

    And me too!

    :w00t:

    gsc_dba

  • Kiara

    SSCarpal Tunnel

    Points: 4075

    Very good question topic. I learned something - which is always the point!

    -Ki

  • OCTom

    SSChampion

    Points: 11755

    It's impossible to answer this. My mind is in an infinite loop...

  • SQLRNNR

    SSC Guru

    Points: 281210

    I thought the question was good and it isn't a question of it being two questions. The joining statement used in this case "in other words" causes the second question to override the first question. Both questions were driving at the same point and the only question needing answered was the second one.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715446

    Arrgggghhhhh.

    My apologies. The second sentence was intended to be an example, not part of the questions and I inadvertently phrased it backwards.

    I've awarded back points to everyone so far and corrected the question to make "yes" answers to both questions

  • Damian Widera-396333

    Ten Centuries

    Points: 1186

    I chose YES as the "second " sentence was OK 🙂

    Hence the "first" question should has answer to "NO"

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET

Viewing 13 posts - 1 through 13 (of 13 total)

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