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 «««1617181920»»»

Forum Etiquette: How to post data/code on a forum to get the best help Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 7:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:47 AM
Points: 351, Visits: 335
All,

Good points everyone on the perils and pitfalls of getting a well formed question.

I would like to also add that when answering the questions that the some thought and effort has been put into the answer. Often times, especially in the "stack" forums, I see a link to an article that doesn't even come close to the answer or an answer that doesn't even come close to solving the problem.

Also, the level of arrogance of some of the "MVP's" is amazing. From the "how dare you ask a simple question" to outright disdain for people, who might not be at the same level as the high rated people of the forums.

I appreciate that "what would you use" type of questions like "stored procedures vs. inline SQL", "WPF vs. winforms", "in memory vs. tempory tables", etc are not closed and shut down as not being a "real question". A thread where people can give their opinions can really shine some light on a difficult subject.

I really appreciate the level of knowledge and help on this site that is missing on some of the other forums. Stay the course everyone.


Anton



Post #1460232
Posted Wednesday, June 5, 2013 1:16 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:19 PM
Points: 36,793, Visits: 31,251
aochss (6/5/2013)
All,

Good points everyone on the perils and pitfalls of getting a well formed question.

I would like to also add that when answering the questions that the some thought and effort has been put into the answer. Often times, especially in the "stack" forums, I see a link to an article that doesn't even come close to the answer or an answer that doesn't even come close to solving the problem.

Also, the level of arrogance of some of the "MVP's" is amazing. From the "how dare you ask a simple question" to outright disdain for people, who might not be at the same level as the high rated people of the forums.

I appreciate that "what would you use" type of questions like "stored procedures vs. inline SQL", "WPF vs. winforms", "in memory vs. tempory tables", etc are not closed and shut down as not being a "real question". A thread where people can give their opinions can really shine some light on a difficult subject.

I really appreciate the level of knowledge and help on this site that is missing on some of the other forums. Stay the course everyone.


Anton


Absolutely agreed. I do try to keep in mind that people that are asking the questions are sometimes really under the proverbial gun and that email and forum posts leave a lot to be desired when it comes to the tone of a post.

I'll also state that some folks that ask the questions are downright rude or whiney in their requests and responses. For example, take a look at the quoted response I got from someone on this very article in my previous post to this one. I've actually seen both sides spend more time arguing an almost totally unrelated point that it would have taken to read a question or response, evaluate what was said, and respond properly and thoughtfully (or just say, "I dunno").

Arrogance and poor manners comes from both sides of the house (on every forum... not just this one and some are a whole lot worse than this one ever was or ever will be) and I'll be the first to agree that there's really no room for it by the people requesting the help nor the respondents. That, not withstanding, everyone does need to realize that even a saint can have a bad day and a lot can be lost in the written rather than the verbal word.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1460405
Posted Wednesday, June 5, 2013 3:53 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:38 AM
Points: 1,780, Visits: 582
Great article, Jeff..
Awesomely presented and well explained article about presenting and putting your question in correct way.
Thanks Jeff.
Post #1460476
Posted Wednesday, June 5, 2013 3:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 2:35 PM
Points: 35, Visits: 190
Could you add another paragraph to the article with the directions for putting code in the scrolling window? It would be great to have those posting tips in the same article with your excellent explanation of how to generate test tables and data.

Thank you
Rosalind



Post #1460477
Posted Wednesday, June 5, 2013 4:08 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:19 PM
Points: 36,793, Visits: 31,251
pchirags (6/5/2013)
Great article, Jeff..
Awesomely presented and well explained article about presenting and putting your question in correct way.
Thanks Jeff.


Thank you very much for the feedback. I appreciate it.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1460481
Posted Wednesday, June 5, 2013 4:10 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:19 PM
Points: 36,793, Visits: 31,251
rphilips (6/5/2013)
Could you add another paragraph to the article with the directions for putting code in the scrolling window? It would be great to have those posting tips in the same article with your excellent explanation of how to generate test tables and data.

Thank you
Rosalind


Excellent suggestion, Rosalind. I'll add it to the article and resubmit it for republishing. Thanks for stopping by.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1460482
Posted Wednesday, June 5, 2013 4:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:25 AM
Points: 136, Visits: 443
I'll be honest and admit that I did not read the 17 pages of comments over the last 6 years.

I will tell you that I agree with you 100%. I am a mixed developer working in Sql Manage, Visual Studio, and Dreamweaver, so I get to throw in chunks of code into various webpages and the first thing I do is to do a code formatting so that I can see what I am working in.

Low and behold some non-tech person (like a copywriter) wants to change how things are displayed and it breaks. I get the "help me" call and open up the file to find all the code has been left-justified, or the text editor says my collapse points have changed

I won't even look at the code until it is reformated, and then I will rerun it to confirm the breakage and get the line number of the error.

It is also helpful as I have quite a few designers who don't like closing their html tags.

So... thank you


Director of Transmogrification Services
Post #1460486
Posted Thursday, June 6, 2013 4:38 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: Saturday, July 19, 2014 8:45 AM
Points: 531, Visits: 2,078
Speaking of formatting code, I have a colleague who gets very confused when he has to format his code.
The most amazing example I ran into recently was in the use of a complex and long series of nested case statements.
He just writes it from left to right and when he reaches the end of the screen he hits return (he hates when the editor does that).
And yes, he has a wide screen - wider than mine - which adds some special effects when I have to read his code.
We have been working 30 years together - and not a thing has changed. Needless to say, I have stopped trying to change his habits.
Fortunately, he is a very smart guy...

PS
Jeff, how long did it take you to unformat that sample code? Is there a tool to do that?
Post #1460611
Posted Thursday, June 6, 2013 8:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:25 AM
Points: 136, Visits: 443
Michael Meierruth (6/6/2013)
... how long did it take you to unformat that sample code? Is there a tool to do that?


When I shrink CSS files down I replace all line breaks and tabs with spaces, then replace double-spaces with singles... and then I replace } with } + line feed


Director of Transmogrification Services
Post #1460711
Posted Thursday, June 6, 2013 5:57 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:19 PM
Points: 36,793, Visits: 31,251
Michael Meierruth (6/6/2013)

PS
Jeff, how long did it take you to unformat that sample code? Is there a tool to do that?


If you're talking about the single line code example in the article, it took 0 time to reformat that code to something readable because I actually wrote the formatted code first, then deleted the comments, converted all tabs and all CRLF pairs to single spaces, deleted the dupe spaces (using your code, by the way), and set everything to lower case.

There are a couple of code reformatters on the web and, of course, Red Gate has a good one, but none of them format or can be made to format the code the way I like it. Of course, anything is a very good improvement of the single line method of posting code.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1460930
« Prev Topic | Next Topic »

Add to briefcase «««1617181920»»»

Permissions Expand / Collapse