SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / Page compression / Latest Posts

RE: Page compression

Damian Widera-396333 — Sat, 28 May 2011 03:07:53 GMT

I chose YES as the "second " sentence was OK :) Hence the "first" question should has answer to "NO"

RE: Page compression

Steve Jones - SSC Editor — Fri, 27 May 2011 09:11:08 GMT

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

RE: Page compression

SQLRNNR — Fri, 27 May 2011 09:05:22 GMT

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.

RE: Page compression

OCTom — Fri, 27 May 2011 06:41:23 GMT

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

RE: Page compression

Kiara — Fri, 27 May 2011 06:40:22 GMT

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

RE: Page compression

gsc_dba — Fri, 27 May 2011 05:38:12 GMT

[quote][b]Chris Houghton (5/27/2011)[/b][hr][quote][b]khullargirish02 (5/27/2011)[/b][hr]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?Noif 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:[/quote]Same here - I answered the first question as a no.:rolleyes:[/quote]And me too!:w00t:

RE: Page compression

mohammed moinudheen — Fri, 27 May 2011 04:57:47 GMT

Thanks for the question

RE: Page compression

L' Eomot Inversé — Fri, 27 May 2011 03:10:04 GMT

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).

RE: Page compression

DugyC — Fri, 27 May 2011 03:09:29 GMT

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.

RE: Page compression

Chris Houghton — Fri, 27 May 2011 02:29:45 GMT

[quote][b]khullargirish02 (5/27/2011)[/b][hr]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?Noif 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:[/quote]Same here - I answered the first question as a no.:rolleyes:

RE: Page compression

khullargirish02 — Fri, 27 May 2011 02:04:06 GMT

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?Noif 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:

RE: Page compression

Koen Verbeeck — Fri, 27 May 2011 00:06:52 GMT

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 correctI chose NO, but apparently that was the wrong one, although I meant to answer the first question.

Page compression

Steve Jones - SSC Editor — Fri, 27 May 2011 00:00:31 GMT

Comments posted to this topic are about the item [B]Page compression[/B]