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 «««1234

Data Typing Quandry Expand / Collapse
Author
Message
Posted Thursday, November 18, 2010 1:38 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 13,622, Visits: 10,514
SanDroid (11/18/2010)
da-zero (11/18/2010)
We would prefer your respect for the effort that the author has made to create a question so that people could learn about compression, instead of calling it "dissapointing and lame".


If you look at some of these posts several people asked the author to respond to the fact that they where not able to replicate what he described.

Why where no responses were made?
Did you learn something that was real?
Did you test the concept?

I made an opinionated response about the question and it's content and that is On Topic discussion.

IMHO: Attacking those opinions and calling them Babble and putting Off Topic mis information in the same paragraph helps nobody learn and clarifies nothing.


I do not call "dissapointing and lame" an opinionated response. I'm sure there are more people who learned something from the question (e.g. metadata overhead for compression) than learned something from the fact that there is no SQL Server definition of "defined row size". So yes, I did learn something that was real. And I did not test the concept, as it is already crystal clear.

So you can call something dissapointing and lame and call it opinionated, but if someone else calls your arguments "babble", then there is a problem.
Pot, kettle, anyone?




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 #1023147
Posted Thursday, November 18, 2010 4:07 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 1,616, Visits: 1,543
UMG Developer (11/18/2010)
[quote]SanDroid (11/18/2010)
If you look at some of these posts several people asked the author to respond to the fact that they where not able to replicate what he described.


Contrary to popular beliefs, I don't sit around all day waiting for someone to post comments. In reality, I was up at 3 AM on the day this question was posted. In the past 48 hours (Tues/Wed), I spent 21 hours in airports or on an airplane. So, i apologize that I haven't had an opportunity to read all of the comments yet much less respond to them.




My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1023217
Posted Thursday, November 18, 2010 4:50 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Robert Davis (11/18/2010)
[quote]UMG Developer (11/18/2010)
[quote]
Contrary to popular beliefs, I don't sit around all day waiting for someone to post comments. In reality, I was up at 3 AM on the day this question was posted. In the past 48 hours (Tues/Wed), I spent 21 hours in airports or on an airplane. So, i apologize that I haven't had an opportunity to read all of the comments yet much less respond to them.


Robert,
Good to hear from you and I do not want you to take the comment in that post out of context.
It was in a chain of responses to a post from someone that continually be-littles other posters and auithors opinions in this forum day after day.
He has even directly flamed QOTD authors in open posts.
Just recently he called a QOTD authors posted question "Stupid" and asked them to never post again.
I have respect for this persons knowledge, but have lost repsect for his words long ago.
The continual insistance that his comments and opinions are Gospel and everyone elses just Bable are shelfish, disrespectfull, and one sided.

BTW: If you can help clear up the ambiguity some of the other posters and I noticed by directing us to any documentation or training material that uses the same wording of "defined row size" you used in your question, I will happily edit my orginal post to a blank.

Much respect and thank you...
Post #1023229
Posted Sunday, November 21, 2010 3:04 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 8,738, Visits: 9,284
An excellent question.

I didn't see any ambiguity in it: "defined row size" is not a reserved phrase in connection with SQL server, but then neither are most of the other phrases that occur in discussion of SQL Server - we use the English language (or sometimes other languages) and for the most part vocabulary is general English, not SQLS specific.

When I see bad questions or sloppy explanations I comment on it. I didn't see either of those here. I did see a lot of what I think are ill-considered (and in some cases mildly offensive) comments, apparently made be people who were so upset at getting it wrong that they had to attack the question (and in some cases its author) rather than admit their own inability to read plain English.

I liked Hugo's comment - and disliked the disgraceful and offensive ad hominem attack made on him by another commenter.


Tom
Post #1024081
Posted Wednesday, November 24, 2010 11:04 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 1:51 PM
Points: 21,644, Visits: 15,317
Wow, I learned something good here.

Thanks




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1026067
Posted Friday, March 4, 2011 6:35 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, August 17, 2014 2:48 PM
Points: 3,352, Visits: 1,481
A bit late, granted, but I just wanted thank the author for what I considered to be a good question.
Post #1073276
Posted Monday, April 4, 2011 9:48 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 4:40 PM
Points: 654, Visits: 375
Great question, thanks! I went for tinyint on the assumption it was 1 byte of storage and compression overhead - got it wrong, but learned something new :)
Post #1088407
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse