SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Manners


Manners

Author
Message
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86191 Visits: 41096
Heh... the way I diffuse it at work is I tell the offender to go to his/her "corner" and come back when they calm down. Hasn't failed yet. It's kinda like you throwing someone off the field for using foul language in front of the kids.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39399 Visits: 38552
Jeff Moden (4/7/2009)
Heh... the way I diffuse it at work is I tell the offender to go to his/her "corner" and come back when they calm down. Hasn't failed yet. It's kinda like you throwing someone off the field for using foul language in front of the kids.


Only they don't get to come back after calming down. They are gone for the duration of the game. Longer if the club/CHSAA get involved and deem it appropriate to ban the offender from future games.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Mad Hacker
Mad Hacker
Right there with Babe
Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)Right there with Babe (756 reputation)

Group: General Forum Members
Points: 756 Visits: 414
I think that the standard rule of thumb one should use when seeking somone's assistance is that a "reasonable" attempt should be made to troubleshoot and resolve an issue before requesting assistance. I've always attempted to learn as much as possible about an issue before seeking the assistance of someone else. One should also include as much supporting information as possible when describing the problem.

What I really hate is the proverbial responses that are limited to "it didn't work, now what?". To me that is a clear indication that the person requesting assistance is not sincere in learning to resolve their own issue, but merely wants someone else to slave out the solution and deliver it on a silver platter. If someone doesn't have the time display the proper etiquette when requesting my assistance, then why should I waste my time in assisting them?

Personally, I'm glad that you put that yahoo in his place Steve.



Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86191 Visits: 41096
Lynn Pettis (4/7/2009)
[quote]Jeff Moden (4/7/2009)
Only they don't get to come back after calming down.


BWA-HAA!!! That's not a fault... that's a feature. :-P

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62657 Visits: 19111
Surf Bum (4/8/2009)
Personally, I'm glad that you put that yahoo in his place Steve.


I'm not sure I did much. Lynn did a good job of turning things around.

I can understand just wanting an answer. If you post on a photography site (or some site where you're an amateur) at some point, if you've tried and shown that you have thought about it, you might just want an answer.

And it's probably appropriate to give one if the person has made an effort, and is stuck. You can probably still teach them, but along with the answer.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
JJ B
JJ B
Mr or Mrs. 500
Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)

Group: General Forum Members
Points: 515 Visits: 2859
I don't post questions often. I find that if I do the research, I can usually solve the problem. This is just to say that I do not have a lot of experience posting questions and getting answers, or visa versa.

Here is a question for the people who tend to have the answers: It would be my preference and inclination to post a question that has all those details that you say you are looking for. I also spend a lot of time trying to write clear descriptions and discuss solutions tried already. The problem is that this kind of post would probably end up being pretty long--especially because if I get to the point that I actually have to post a question, (I'm near to tears and) we are probably not talking about a simple issue. I've been told by people that they do not like to read my posts because the text is too long. So, my worry would be that if I included all the background details, no one would read my post.

Do you ever skip the long ones just because they are long? Would a shorter post with less background details be preferable in some cases? (The whole "it depends" kind of thing.) It kind of seems like a dumb question given this entire discussion. However, I wonder if the best way to get a response is somewhere in the middle. Remember, I don't have a lot of experience with question posts. Maybe you really do mean it that you want all that detail. I'm curious to hear what people have to say for future reference.

Thanks. - JJ
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39399 Visits: 38552
Here is my take. When you look at your post, could someone with no knowledge of the problem domain understand the problem you are presenting. If so, then you have provided enough information. Does that help?

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
JJ B
JJ B
Mr or Mrs. 500
Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)

Group: General Forum Members
Points: 515 Visits: 2859
Your reply makes perfect sense.

I still wonder if a human element isn't involved. It seems to me that a shorter post might draw someone in enough to be curious and interested enough to ask further questions. A longer post might turn someone off from even trying to answer or reading the full problem statement even though the longer post contains all the necessary information. I think that most humans don't want to read a lot of text. It is why publishers talk a lot about white space. But I could be wrong about the people here.

I was just curious if anyone had thought about length of posts and their real reactions to them. Kind of along the lines of: be careful what you ask for.

Thanks for your reply.
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39399 Visits: 38552
In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be well formatted with appropriate white space. The sample data readily consumbable without reformatting. The sample data easily comparable to the output.

You only need enough of an explaination so that people can understand the problem. They don't need all the details of the system, nor necessarily all the data from the tables, either in rows or columns. Just what is needed to understand and assist in solving the problem.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39934 Visits: 32653
I'd have to say it falls into it depends. I don't mind reading a bit, but sometimes people post several hundred lines of code and, quite frankly, I don't want to have to plow through page after page of poorly written code. Especially when, after wondering for a while and posting a series of suggestions, you get a response that says they can't rewrite anything, they just want it to run faster... That's clearly not you, but you can see where really long posts might push people away after a while.

It just depends on the query, how the question is posed. Personally, I like to see the question up front and the explanation about the question second. That way I can decide if I want to read everything rather than skip it because it looks long. But then, I'm lazy and not nearly a saint like Lynn.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search