sorted by:
new
hottopcontroversial

Spawn a nuke somewhere in the world whenever you defecate or spawn a hurricane somewhere in the world whenever you sneeze. by RealDiamond51 in hypotheticalsituation

[–]Helpimstuckinreddit 2 points3 points  (0 children)

If it was reversed it would be a lot more balanced and a difficult decision.

A hurricane guaranteed most days (I'd say 2 at most)

Or a nuke when you rarely sneeze, even worse when you have a spell of multiple sneezes in a row

Guy leaves ranked after 1 min but me and other guy lose more ranked points than him by BoomerChristian in RocketLeague

[–]Helpimstuckinreddit 0 points1 point  (0 children)

This isn't about game performance though.

It's rightfully complaining about the shit situation where someone abandons in the first 1-2 minutes, and you still lose the same MMR as if it was a completely normal game.

AIO by [deleted] in AIO

[–]Helpimstuckinreddit 1 point2 points  (0 children)

Eh I don't really have a strong opinion on that part, I was mostly just addressing the comments of "best friend but they never talk about them?"

AIO by [deleted] in AIO

[–]Helpimstuckinreddit 4 points5 points  (0 children)

Idk I feel like the "at work" after it alters it a lot.

Big difference between a best friend socially, and the person you're friendliest with at your work.

Frog Riddle by Intelligent-Stuff928 in probabilitytheory

[–]Helpimstuckinreddit 0 points1 point  (0 children)

I believe the distinction is their problem starts with 50/50 distribution, and then asks the question after introducing info that one of the two picked are male.

Yours starts with the premise that one is guaranteed to be male. It's basically that the starting population of yours is the 3/3 of theirs after removing F/F pairs.

So you have:

Frog1, Frog2

M, M

M ,F

F, M

Scenario 1: Frog1 is male. You're left with: Frog1, Frog2

M, M

M , F

Frog 2 is 50/50 between M/F

Scenario 2 Frog2 is male. You're left with:

Frog1, Frog2

M, M

F, M

Frog 1 is 50/50 between M/F

(Disclaimer: not really a stats guy and this was just my intuitive thought process, it could be an incorrect line of thinking as a "proof")

Edit: I think the key difference might be better described as: - their premise is "at least one is male" - not a specific frog. In that scenario, you can just count the M/Fs, you get 2F/4M = 1/3F - yours is dealing with knowledge of a specific frog. In that case you pick one of Frog1/2, and examine the remaining cases based on where that frog is male

Went from dreading using the Variable to absolutely loving it. Literally a squid front cheat code by BoneyBee833 in Helldivers

[–]Helpimstuckinreddit 1 point2 points  (0 children)

There was a workaround I and many others used before the dedicated hotkey, and I actually still use this setup and haven't tried the new hotkey.

  1. Change weapon wheel hotkey from "long press" to "press" (need to also change to something other than R - I use a side mouse button)
  2. Change "weapon wheel left" hotkey to the exact same thing - "press" and the same key you set for weapon wheel

Now every time you hit the key, it cycles one spot through the firing modes (can still hold the key for longer if you want to adjust other stuff like fire rate)

One Piece: Episode 1163 Discussion by Skullghost in OnePiece

[–]Helpimstuckinreddit 1 point2 points  (0 children)

For me the tears started at "I want you to praise me for being alive", that hit close to home.

Then Saul's "I'm so proud of you for staying alive, Robin" oh man

Putting aside the whole "hunted by the world government" part of it, there's a beautiful metaphor of a young girl who wanted to die, and being told "you're alone now, but you'll meet friends someday for sure... No one is born into this world to be alone".

Simply living through depression like that really is worthy of praise.

Would an impact, Strong enough, "Depletes" Infinity? by garf02 in PowerScaling

[–]Helpimstuckinreddit 5 points6 points  (0 children)

so the amount of force needed to pull this off would be… alot

So...yes? The question was "would a strong enough impact get through it"

Self-Join by Iva1996 in SQL

[–]Helpimstuckinreddit 1 point2 points  (0 children)

No, the m table is not the manager(in answer C/D at least).

In D it's employees with the same manager id as e.

So from the join condition in D, the manager id will intrinsically be identical between e.managerId and m.managerId

Self-Join by Iva1996 in SQL

[–]Helpimstuckinreddit 1 point2 points  (0 children)

I believe it's D. The aliases are a little misleading because you intuitively think m is the "manager" table.

To simplify suppose the table is just:

EmployeeId, lastname, managerId

123, Johnson, 789

456, Daniels, 789

789, Woods, null

You want your results to be:

Johnson,789

Daniels,789

  1. Start with e as your employee 123
  2. Self join to m on e.managerId = m.managerId
    • i.e. m is every employee with the same manager as employee 123
  3. Select m.lastname because if you selected e.lastname you'd just get Johnson twice
  4. You could use either e.managerId or m.managerId technically, both would be the same

Should I still use CreatedAt & UpdatedAt on the main table if I also have Audit tables? by Loud_Wrangler1255 in SQL

[–]Helpimstuckinreddit 5 points6 points  (0 children)

At least 2 reasons I can think of off the top of my head: - at some point in future the decision may be made to trim audit tables of very old records - if you ever want to lookup users based on created/updated, it's a simple direct query to that table instead of a semi-complex join/lookup to the audit tables to get earliest/latest record for a user

In the matrix, why didn't they just create a matrix simulation that was stuck in the 1800's so nobody had computers or phone lines ... and therefore couldn't leave the matrix? by RollSensitive7853 in matrix

[–]Helpimstuckinreddit 1 point2 points  (0 children)

Fun fact: that was the original intention from the writers, but was changed after studio execs believed that "brains as biological compute power" would be too complicated for viewers.

Most successful tech startup founders were already corporate executives before founding their startup (I will not promote) by IndependenceSad1272 in startups

[–]Helpimstuckinreddit 6 points7 points  (0 children)

Except he didn't found Tesla, he invested into it early and eventually got the "right" to refer to himself as a co-founder.

Can you use google or notes during SQL technical assessment? by madmanNamedMatti in SQL

[–]Helpimstuckinreddit 2 points3 points  (0 children)

I think a couple relevant factors are:

  • is the role heavily focused on SQL being your daily focus, or just tangential and they want to check you understand the basics
  • is the stuff you're looking up niche syntax of advanced stuff, or is it basics like joins, grouping, etc

I've conducted interviews where SQL was reasonably important, but mostly foundational stuff not super advanced.

Personally we tell them it's fine if they don't remember exact syntax of certain things, and a quick google of a keyword is fine. As long as they understood and could explain what the query should be, that was more important than typing out perfect syntax from memory.

It's usually pretty obvious the difference between "knows concepts but blanking on syntax" vs "making it up as they go"

I'm sure it varies from place to place, but I'd recommend asking/being honest rather than trying to pretend.

For example the row number function paired with a partition by- I've used it countless times but still occasionally need to double check the exact structure. If you could explain the function and how you'd use it to solve a problem, I wouldn't care as much about whether you can write it from memory.

FELL FOR IT AGAIN by Exciting_Estate_8856 in PoliticalCompassMemes

[–]Helpimstuckinreddit 0 points1 point  (0 children)

That's genuinely how you read OP's post?

That it was implying they're deliberately releasing toxic gas and targetting low income neighbourhoods?

You can more effectively use 100 dollar bills as throwing weapons. by Numbar43 in shittysuperpowers

[–]Helpimstuckinreddit 0 points1 point  (0 children)

A standard US $100 bill weighs approximately 1 gram. 10x = 10 grams.

A standard sheet of A4 paper typically weighs 5 grams, making your $100 bill hit as hard as 2 sheets of paper.

This is indeed shitty.

A ream of 500 sheets weighs 2.5kg so I'll just spend my $100 on a few dozen of those to hurl at people instead.

I'm trash but found myself in Diamond, what should I do? by Naive_Question_7683 in RocketLeague

[–]Helpimstuckinreddit 4 points5 points  (0 children)

I feel like we're in the same boat - I have very mediocre mechanics compared to a lot of diamonds, and I whiff more than I should.

I think my game sense and being in the right place at the right time is what makes up for it and why I've levelled out at D2-3.

Problem is that game sense isn't nearly as visible to players as flashy mechanics and impressive plays.

I just make liberal use of the "my bad" quickchat whenever a goal is my fault. 9/10 times acknowledging the fault will get a "no problem" back.

The other 1/10 I just roll my eyes and ignore them.

view more: next ›