Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 @ 10:36 AM
Points: 31,362, Visits: 15,823
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 13,636, Visits: 11,508
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 LessThanDot.

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: Sunday, September 21, 2014 12:18 AM
Points: 375, Visits: 116
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: Yesterday @ 8:17 AM
Points: 558, Visits: 1,495
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:11 PM
Points: 7,920, Visits: 9,646
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: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Thanks for the question

Mohammed Moinudheen
Post #1116128
Posted Friday, May 27, 2011 5:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:42 AM
Points: 1,309, Visits: 1,573
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, June 19, 2014 8:00 AM
Points: 363, Visits: 1,425
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: Today @ 6:28 AM
Points: 2,666, Visits: 4,088
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