Page compression

  • Comments posted to this topic are about the item Page compression

  • 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

  • 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:

  • 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:

  • 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]

  • 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

  • Thanks for the question

    M&M

  • 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

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

    -Ki

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

  • 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

  • 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

  • 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 12 (of 12 total)

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