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 12345»»»

Forum Etiquette: How to post data/code on a forum to get the best help Expand / Collapse
Author
Message
Posted Monday, November 26, 2007 9:22 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 12:23 PM
Points: 35,403, Visits: 31,965
Comments posted to this topic are about the item Forum Etiquette: How to post data/code on a forum to get the best help

--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 #426135
Posted Monday, November 26, 2007 10:09 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 12:23 PM
Points: 35,403, Visits: 31,965
Heh... guess I hit someone's "sweet" spot... got 1 vote with 1 star so far and they didn't even take the time to post what their complaint was :D

--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 #426149
Posted Monday, November 26, 2007 10:23 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:20 PM
Points: 1,276, Visits: 1,135
Hey Jeff, people trying to get answers in the newsgroups can certainly learn from your experience. The only thing I would add is that it also helps if people post expected results (the explanations aren't always clear) and the thing about cross-posting to multiple newsgroups instead of posting the same question to 10 different newsgroups 10 different times.
Post #426157
Posted Monday, November 26, 2007 11:04 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 12:23 PM
Points: 35,403, Visits: 31,965
Thanks for the feedback, Mike.

Yep... folks on news groups could learn a thing or two about how to post questions, as well. Some folks just don't understand how much better an answer you can get if you post some easy to use test data.

And, I absolutely agree... post on one thread and post some expected results to go along with the data.


--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 #426182
Posted Tuesday, November 27, 2007 12:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 25, 2011 3:52 PM
Points: 31, Visits: 18
Hi Jeff

You raise a point that goes beyond just posting on forums - In the general office situation this is also common: People ask questions without being clear and actually expect you to write their code for them. Worse still, they hold you accountable if it doesn't work. It never ceases to amaze me how people who don't have a clue would sooner spend an entire day trying to get someone else to solve their problem than spend the day doing some research to figure out and understand SQL better (and there is no shortage of fantastic resources: books online, books from Amazon etc.)
In the office situation, I've resorted to giving answers like "You could probably solve this using the DateDiff function, you can read up on how it works in books online" - point someone in the right direction but don't write the code for them. This way they have to figure it out for themselves and be accountable for their solution, and they are far less likely to ask you the same question again in a weeks time.

Its a sad truth that there are people out there who claim to be programmers when all they can do is copy code off the web and don't really understand the fundamentals of programming.

I couldn't agree more with your statement that if you don't take your code / problem seriously, why would anyone else.
Post #426198
Posted Tuesday, November 27, 2007 1:57 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: 2 days ago @ 5:24 AM
Points: 588, Visits: 2,559
I couldn't agree more with Jeff. I really enjoy solving problems if they are well presented, and loathe doing so if the problem is badly expressed. What irritates me is when a question can be answered by anyone by a simple search on the internet.

It is a really good habit to take care and thought in describing a problem. I suspect that the very process of presenting and describing a problem often makes the solution suddenly pop into the head.



Best wishes,

Phil Factor
Simple Talk
Post #426214
Posted Tuesday, November 27, 2007 2:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 6:05 AM
Points: 40,258, Visits: 36,681
Nice. I'm also a little tired of people looking for a free lunch.

Problem is, those who need it most will likely not be the people who read it.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #426234
Posted Tuesday, November 27, 2007 5:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 14, 2009 8:38 AM
Points: 1, Visits: 20
My pet peeve besides those given already: Poor choice of subject. So many "Newbie needs help" and "help me" threads abound. I'd much rather see a topical subject.
Post #426311
Posted Tuesday, November 27, 2007 6:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, October 5, 2014 10:21 AM
Points: 2,717, Visits: 3,855
My fingers are crossed that people actually read this article!

Maybe get Steve to include something like this in the new user sign-up... :D


______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Post #426330
Posted Tuesday, November 27, 2007 6:53 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, January 6, 2012 2:39 PM
Points: 954, Visits: 683
You realize that the only ones who will read that article are those that know how to post However, is it just me or did Jeff's post of the "Bad Code" not show up? Had a slider, but no code.
Post #426353
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse