Post reply

Page compression

  • May 27, 2011 at 12:00 am

    #72275

    Comments posted to this topic are about the item Page compression

  • May 27, 2011 at 12:06 am

    #1330784

    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

  • May 27, 2011 at 2:04 am

    #1330807

    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:

  • May 27, 2011 at 2:29 am

    #1330814

    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:

  • May 27, 2011 at 3:09 am

    #1330830

    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]

  • May 27, 2011 at 3:10 am

    #1330831

    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

  • May 27, 2011 at 4:57 am

    #1330881

    Thanks for the question

    M&M

  • May 27, 2011 at 5:38 am

    #1330905

    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

  • May 27, 2011 at 6:40 am

    #1330934

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

    -Ki

  • May 27, 2011 at 6:41 am

    #1330935

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

  • May 27, 2011 at 9:05 am

    #1331054

    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

  • May 27, 2011 at 9:11 am

    #1331058

    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

  • May 28, 2011 at 3:07 am

    #1331315

    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