Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Page compression Expand / Collapse
Author
Message
Posted Friday, May 27, 2011 12:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
Comments posted to this topic are about the item Page compression






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1116014
Posted Friday, May 27, 2011 12:06 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 15,501, Visits: 13,163
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1116018
Posted Friday, May 27, 2011 2:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 29, 2016 4:07 AM
Points: 381, Visits: 126
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....
Post #1116046
Posted Friday, May 27, 2011 2:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 30, 2016 8:36 AM
Points: 590, Visits: 1,658
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....


Same here - I answered the first question as a no.
Post #1116055
Posted Friday, May 27, 2011 3:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1116073
Posted Friday, May 27, 2011 3:10 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 9,824, Visits: 11,894
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
Post #1116074
Posted Friday, May 27, 2011 4:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 8:46 PM
Points: 2,333, Visits: 3,896
Thanks for the question

M&M
Post #1116128
Posted Friday, May 27, 2011 5:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 2, 2016 5:08 AM
Points: 1,532, Visits: 1,942
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....


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


And me too!


_____________________________________________________________________________________
gsc_dba
Post #1116155
Posted Friday, May 27, 2011 6:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 30, 2015 8:11 AM
Points: 363, Visits: 1,426
Very good question topic. I learned something - which is always the point!

-Ki
Post #1116185
Posted Friday, May 27, 2011 6:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, January 30, 2015 7:36 AM
Points: 2,723, Visits: 4,152
It's impossible to answer this. My mind is in an infinite loop...
Post #1116186
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse