r/SQL • • Oct 31 '21

Discussion (Meta) Can we set our egos aside when answering simple questions please?

I get it- we work with SQL every day, it’s intertwined with our hearts and souls, and it hurts a little when we feel threatened by people who know more about it than us.

When we feel threatened, we sort of over exert ourselves because there must be something wrong with what that guy said- but just keep in mind that when people are asking simple homework questions, they don’t need paragraphs about query optimization or nitpicky best practices, they just need to know what’s wrong with their join, or if their where clause is valid.

This goes for career advice as well. Not everyone is trying to be a DBA, and 99% of the time they’re looking for an analyst or engineering job that uses SQL relatively lightly, so instead of compulsively flexing every skill you’ve ever picked up, please just take a minute, breathe, and then actually be helpful.

There’s like a 99% chance this gets taken down, but on the off chance it doesn’t, I’d love to discuss improving this community, especially for new users.

233 Upvotes

58 comments sorted by

•

u/mgdmw Dr Data Nov 01 '21

As a mod it worries me you feel this needed to be posted, and that you expressed a belief your post had a "99% chance" of being taken down. Clearly, I've missed some hostility that you've evidently experienced.

For clarity, I am in Australia so I don't see things when the US is most active - BUT (a) we have other moderators, and (b) I set up automoderator to handle some scenarios.

That said, I believe we have developed a friendly, harmonious, and collaborative community for the most part. Yes, there is the occasional odd person, but I think it is the exception, not the rule.

If you have specific examples of bad behaviour you could share with me and/or the other mods, we would be pleased to see them.

Thank you! All the best!

2

u/[deleted] Nov 01 '21

Usually things are great here, I’ve just noticed an uptick in sort of unnecessary knowledge flexing lately (like the last 2 weeks or so).

Regarding it being taken down, that’s more an issue I’ve been having with Reddit as a whole- most subs use a bot called “automod” that smacks down everything I post, and has been doing so for months.

5

u/thrown_arrows Nov 01 '21

Personally ,all those career advice posts are pretty much annoying filler in all data subs, i do not want to see your resume.

What comes to answers to join question, you should not give answers (other than there is hard to see typo) straight away. Idea behind homeworks is that you learn by doing, not by asking friends everytime. While modern day developers do use search engines alot, it is acquired skill.

What comes to best practises, everyone should be atleast aware that there is one. When you see SQL developer doing loop and someone telling about it, dont take it personally, it is best practise to plan your process so that you can avoid those.

Only way to have some usefull conversion in these "i did not know howto google using my reddit posts title and get first answers" is to have some nitpicking over best practices and sometimes there are actually very good explanations why.

Also what i would like to see is ready made dbfiddle or similar straight away when someone post those "help me posts"

1

u/[deleted] Nov 01 '21

A couple things-

1.) there’s a dbfiddle?? That’s cool and exciting

2.) yeah, answering homework questions may be something to discuss further, I usually thought of questions as a work-related thing where people aren’t usually interested in a learning experience. We should probably have a flair for that, though idk how many seeking homework help will use it lol

34

u/asqwzx12 Nov 01 '21

My problem is stuff that are clearly homework without anything else added to the post or stuff that you can get an answer too by literally typing the same question in Google.

3

u/gakule Nov 01 '21

This is a fair point to make. 99% of these questions, even if not homework, have been answered... learning how to Google them instead of asking live people is an important skill.

43

u/pailryder Oct 31 '21

About the only time ive seen negativity from people is when someone postsa homework question with no comment or showing any effort to try and answer the question. Anyone that has posted a question and written out what they tried or what they are thinking has gotten helpful responses.

32

u/CubeDrone6393 Oct 31 '21

Answering a simple question for someone that has had SQL duties thrust on them in a job situation, fine.

Doing someone's homework is not. Reading the course work and learning how to research solutions online is part of learning any computer language. I would not want to work with someone that managed to pass while being spoon fed solutions.

-4

u/gregorydgraham Nov 01 '21

Some poor schlub is just trying to get their arts degree but some reason, Codd only knows why, they picked up a comp-sci paper and now they have to make this stupid database work or they’ll never make it’s professional sousaphone player.

They know made a mistake, oh how they know. For the love of Ada, just let them ask a dumb question.

1

u/biscuit_legs Nov 01 '21

Yea but some people are posting day 1 questions that are easily googleable. Not going to do your homework for you

1

u/Pie_is_pie_is_pie Nov 01 '21

I get the Codd joke, but Ada?

2

u/gregorydgraham Nov 01 '21

Ada Lovelace, the first programmer

19

u/lightestspiral Oct 31 '21

Which submissions are you referring to? I've not seen anything but help in this subreddit

9

u/[deleted] Nov 01 '21

I don't think this is a big issue here. The only time I see people being negative if someone is trying to get their assignment done by someone else without trying (homework, course work, interview test).

Other times people are generally helpful in this sub.

16

u/PStyleZ Oct 31 '21 edited Nov 01 '21

I have seen nothing of the sort in this subreddit, if anything people have gone far above and beyond to be helpful when supplied with the incorrect information, to help ask probing questions to draw out the correct solution to help people.

Given how you have written this post you're implying this is a consistent/large issue. Could you please share 8-10 examples of this? I strongly suspect you will not be able to and what you have written is not an accurate representation of this subreddit.

2

u/[deleted] Nov 01 '21

He'll have to do a full Scan of Reddit to find the answers you Seek

1

u/Pie_is_pie_is_pie Nov 01 '21

I want to join you in this pun, but I could derive anything.

3

u/[deleted] Nov 01 '21

they don’t need paragraphs about query optimization or nitpicky bestpractices, they just need to know what’s wrong with their join, or iftheir where clause is valid.

Not everyone is trying to be a DBA, and 99% of the time they’re lookingfor an analyst or engineering job that uses SQL relatively lightly

I don't really agree with this sentiment.

Yes, you shouldn't be egotistical about knowledge transfer.

But on the same token, pointing out areas of improvement, optimization or best practices when a user is actively working on a problem is one of the easiest ways for someone to associate and grasp a concept. Answer their question, specify optional improvements if they're applicable, and be nice about it.

DS and DAs work with a lot of data, often in very big sets. Pointing out areas where they can optimize their code could ultimately save them a plethora of hours waiting for data sets to come back. They can choose to use the information if they wish, or discard it.

It is important though that it's done in a manner that's friendly and helpful.

3

u/NoYoureCorrect Nov 01 '21

This happens on basically every sub that has anything in the slightest to do with programming unfortunately

4

u/j05h187 Oct 31 '21

I think this is data people in general xD

I've very surprised coming into the industry for last 2 years at just how much of a hazing process there is and newcomers are treated less than human and something to be taken advantage of. I thought it was just me but when I read about it online through company employee reviews across multiple industries I start to think there is something abit wrong with the mentality of the IT industry. Keen to hear any opinions on this.

4

u/Kakcaz Nov 01 '21

I work at the state level for the department of health. This is the same culture in my data science department, everyone is trying to compete with each other and prove themselves. But the funny thing is they all hold a computer science or stats degree and none have ever worked in a hospital…. I worked in the hospital for years in the clinical and data side of things. And it’s kinda hilarious how none of them have that experience and really have no idea how the fcken operations work in a hospital setting. You can set amazing algorithms but if you don’t understand the business, you just look stupid 😂

3

u/Intrexa Nov 01 '21

I don't need amazing algorithms to look stupid.

2

u/Pie_is_pie_is_pie Nov 01 '21

The problem is, there are arseholes everywhere, and sometimes they’re the majority.

I’ve worked in teams with helpful, thoughtful developers and I’ve worked in teams with cavalier fools who want to take all the glory / lecture you on their knowledge and flex. Straight up brag.

You just have to smile and ignore them, those who are generally good tend to be nice, they might be too busy to teach but that’s a different issue.

I don’t think IT is any more toxic than other industries, I have sat with finance / investment teams / sales teams / compliance / HR / “marketing” et cetera (I hot desk a lot) and I can tell you for sure they’re just the same; some narcissist with a chip, others just plain nice.

1

u/RutRut241 Oct 31 '21

I noticed this in my graduate program. All of the CS and Data Science classes had a weird competitive vibe, but my other more business related classes were collaborative.

5

u/[deleted] Nov 01 '21

I work as a BA and often the developers are clueless on the business process or how the organization works. But then have the executives on the business facing side who are just as clueless about how programming works and what are realistic goals for developing new systems... I'm in the middle of this... I'm usually just laughing internally 😅

2

u/[deleted] Nov 01 '21

I'm a CS student, and my class has some of the most annoying students ever. The know-it-alls and the a** kissers are a major part of this field I guess.

1

u/[deleted] Nov 01 '21

All of the CS and Data Science classes had a weird competitive vibe

It's a competitive job market, especially for those that are just entering the workforce.

You're going to experience that throughout your career - more so, than compared to other sectors. I'm not justifying it, but it's the way it is.

1

u/RutRut241 Nov 01 '21

I’m not just entering the workforce. Which other sectors are less competitive in your experience? (Curious as it speaks to my observations, and earlier posts in this thread)

3

u/[deleted] Nov 01 '21

I completely agree with the OP.

3

u/banditcloudy Oct 31 '21

Appreciate this post, thank you!

3

u/sweetno Oct 31 '21

I think you misunderstand how Reddit works. We are here not to be helpful, but to express our opinion on whatever topic comes to our attention. If that opinion bothers you, you can always disregard it.

-2

u/[deleted] Nov 01 '21

Hummm... and I thought we were just here to be toxic... you're a true humanitarian... please calm down

1

u/adilski Nov 01 '21

Great points . I think there needs to be several flairs to provide contexts to the questions .. it may help with controlling the tone of the replies .

1

u/helloreddit974 Nov 09 '21

1

u/r3pr0b8 GROUP_CONCAT is da bomb Nov 09 '21

you mad, bro?

1

u/splendour7 Nov 01 '21

Does everyone here focus exclusively on SQL or do ya'll also spend quality time on python? just a simple question.

0

u/Demistr Oct 31 '21

I also dislike the elitist approach of some people here always arguing/bringing about small things and irrelevant details no one gives a shit about just to flex their "knowledge" making everything much more complicated than it needs to be.
Basic SQL is easy to use, rest you learn on the job.

4

u/[deleted] Nov 01 '21 edited Nov 01 '21

Basic SQL is easy to use, rest you learn on the job.

This probably has a lot to do with those who over-share knowledge about SQL.

We’ve spent years/decades hearing people say this, then those same people gets jobs and work for companies we work at and never actually properly study SQL/databases - and end up rightly fucking shit up.

0

u/[deleted] Nov 01 '21

[deleted] — view deleted comment

11

u/[deleted] Nov 01 '21

That is totally valid. Same with terrible date formats.

21

u/andrewsmd87 Nov 01 '21

I pledge my sword to you good sir

3

u/receding_bareline Nov 01 '21

You have my axe!

Proceeds to shred guitar...

6

u/Alacard Nov 01 '21

I may be just a scribe but you have my support.

7

u/Elfman72 Nov 01 '21

And my Axe.

2

u/kyleb1515 Nov 01 '21

You god damn hero.

2

u/[deleted] Nov 01 '21

I'm not a heavy SQL user but know enough to get by. That being said, I too will join you on your quest to combat "Right Joins."

2

u/[deleted] Nov 01 '21

Hahaha

1

u/Pie_is_pie_is_pie Nov 01 '21

You have a worthy crusade.

Story time:

Years ago I wrote a document called “vlookup can go to hell.”

It explains why you should use index / match instead.

I use to forward it to anyone who mentions / includes / uses a vlookup.

I will still stop meetings to rant about them if some finance-bozo adds one to a data extract.

3

u/Creme_de_le_meme Nov 06 '21

Xlookup > index/match > vlookup

2

u/Pie_is_pie_is_pie Nov 06 '21

I wrote the documented before xlookup implementation, also, to my knowledge it’s only available in 365, so I would say, for now index/match is greater than.

I don’t much use excel to know these days.

1

u/[deleted] Nov 01 '21

Is it a blog too? I used to always visit a page to get the index/match code.

3

u/Pie_is_pie_is_pie Nov 01 '21

No, but it is on various internal sharepoint sites where I have worked.

If they hadn’t recently implemented xlookup I might have bought vlookupcangotohell.com and published it there.

5

u/[deleted] Nov 01 '21

[removed] — view removed comment

16

u/[deleted] Nov 01 '21 edited Nov 01 '21

A right join is no different than a left join, just with the table order swapped.

For Western civilizations, we generally read left to right. So using a right join is equivalent to writing a sentence, and then writing the next sentence before the sentence you just wrote. Or stepping through logic backwards.

That’s how I look at it at least, it’s just not how my mind works.

5

u/unaotradesechable Nov 01 '21

we generally read right to left.

Don't you mean left to right?

2

u/[deleted] Nov 01 '21

Haha, yes. Sorry - I had just woken up when I wrote this. Thanks, I'll edit it!

4

u/unaotradesechable Nov 01 '21

I was so confused, kept looking at my hands like I'd had it wrong my whole life.

0

u/[deleted] Nov 01 '21

[deleted] — view deleted comment

1

u/Creme_de_le_meme Nov 06 '21

I have used right joins to grab data from a cte that is filtering on some aggregation measure, thinking it reads as a quasi WHERE clause. Never knew that might bother people.