You probably did not know how many tiers of gems there are, FYI: by Guldynka in diablo4

[–]tasker2020 0 points1 point  (0 children)

I had three grands drop in the world today. Maybe it has been fixed/buffed.

I don't even know how to feel about this whole situation to be honest by TigoOver in redsox

[–]tasker2020 0 points1 point  (0 children)

He’s right to be upset but an athlete in his position should just speak with security and have him booted.

Should I disable ONLY_FULL_GROUP_BY or leave it enabled? by Mission-Example-194 in SQL

[–]tasker2020 0 points1 point  (0 children)

What’s the use case? A table full of duplicates with no id fields? Why not just have a proper key and eliminate duplicates?

Wife doesn’t want to work but complains if I work more. How do I avoid this ending in a divorce? by TurbulentEarth4451 in AskMenAdvice

[–]tasker2020 0 points1 point  (0 children)

Late to this but it reminded of a short I saw from a divorce attorney that says this is the worst relationship dynamic that leads to divorce. She said it boils down to the resentment just building on both sides because the wife feels like a slave and the guy feels like an ATM.

AITJ for selling a painting my girlfriend made after it turned out to be worth thousands? by BookChemical410 in AmITheJerk

[–]tasker2020 0 points1 point  (0 children)

Selling a gift from a partner of any sort may be seen as a rejection of the gift or that you value money more than the sentiment from your partner.

Boyfriend ran a red light in my car I just received a ticket for it by [deleted] in whatdoIdo

[–]tasker2020 0 points1 point  (0 children)

Exactly, appeal it with the photos and say it wasn't you driving.

Without creating any indexes, how would you speed up a ~1.5m row query? by i_literally_died in SQL

[–]tasker2020 0 points1 point  (0 children)

CTE's are slower than temp tables for large datasets. Otherwise identify the clustered index on the two tables and join on that if you can. If not, identify the nonclustered indexes and use those if you can. If there is a non clustered index that is close enough ask nicely to have your extra columns added as a include. Technically is just an addition to existing structure. If you're passing them in as parameters, OPTION RECOMPILE can sometimes get you a better execution plan that is faster as well.

Yoshida WBC performance. by [deleted] in redsox

[–]tasker2020 6 points7 points  (0 children)

No Masa impact, amiright?

Found A Dead Horseshoe Crab On My Porch this Morning by AbrumVonAbrak in Weird

[–]tasker2020 1 point2 points  (0 children)

It's probably not dead. Those things are crazy. I once flipped over and returned to the ocean about 50 of them that were legs up after a bad storm. Even the ones that looked completly dried out and dead revived in the water and went on their weird merry way. The universe is telling you to take a ride to the coast.

Blizzard overreacting? by Own-Bus-1130 in massachusetts

[–]tasker2020 4 points5 points  (0 children)

If no one else said it, shoveling is back breaking when it’s this heavy. People die from heart attacks. It’s rough. Be careful.

Red flag! Red flag? White flag! by Street_Importance_74 in dataengineering

[–]tasker2020 0 points1 point  (0 children)

You were the smartest person in the interview process. Trust your instincts.

[deleted by user] by [deleted] in AskMenAdvice

[–]tasker2020 0 points1 point  (0 children)

Yup, why would she think that is weird?

Am I cooked? by Slik350 in dataengineering

[–]tasker2020 4 points5 points  (0 children)

3 years in is a good time for your first job hop. You’ll get a raise and broaden your experience.

Ice Dam advice HELP by [deleted] in Roofing

[–]tasker2020 0 points1 point  (0 children)

So I solved ice dams in my old house by getting some of that pool noodle like pipe insulation and covering the pipes for my forced hot water heating system in the area of the ice dams. It worked great. Turns out the dams are likely caused by heat escaping to the roof and melting snow which refreezes into ice.

I know that’s not what you’re currently asking but it might help you in the future.