world World News Hezbollah blames Israel after deadly pager explosions in Lebanon
Jump
politics politics Vance calls booing firefighters "haters" during speech to union
Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 weeks ago 40%

    I hate Walz Vance and love that he got boo'd. That said, I don't understand why everyone is making such a big deal of him calling them "haters". That's literally what that word means. I'm a Walz Vance hater. Many of you are haters. It's a description not a slur.

    Edit: Yeah I fucked this one up royally, didn't I lol? Sorry folks.

    -3
  • mensliberation Men's Liberation Tim Walz is clearly a midwest ‘man’s man’. But he’s the antidote to toxic Maga masculinity
    Jump
    denver_post_comments Denver Post Comment Section Trump speaks from behind bulletproof glass at first outdoor rally since his attempted assassination – The Denver Post
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    4 weeks ago 100%

    Like, I know it really happened. I believe that. But damn if there isn't a voice in a small corner of my mind that won't stop whispering "he faked the whole thing".

    17
  • workreform Work Reform Actors demand action over 'disgusting' explicit video game scenes
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    1 month ago 100%

    Hard disagree. But that's okay, we're allowed to like different kinds of games. Yours isn't any more objective than mine though. If you don't like that kind of thing, just don't play those kinds of games. It's not a threat to you if others enjoy them.

    30
  • politics politics Unearthed photo: Teen JD Vance poses with 3 girls at urinals
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    1 month ago 100%

    Yeah this is a reach. He's a big enough turd we really don't need to stretch this much.

    19
  • historyruins History Ruins Building ruins in Djado, Nigeria
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    Why would someone go about building ruins? Wouldn't you want an actual building with walls and a roof?

    3
  • sql SQL - any and all What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    Yeah, I guess it's a less-used analytic function (function? I think that's the right term here).

    I believe this will only accept DENSE_RANK as the ranking part of this method, which makes sense cause you want a distinct list of ranks to identify the last one. You are right though that it's possible for the record returned by the MAX() to be arbitrary if there are duplicate values in the ORDER BY field. Luckily you can usually handle for that by using multiple fields in the ORDER BY. The conditions in the query that the function operates on top of also play a roll. You can also include a PARTITION BY, but I've only needed to use that a time or two.

    I think one reason I like this more is it's more readable to me. For a lot of the other analytic functions you end up using partitions and additional keywords like "ROWS BETWEEN UNBOUNDED AND ....etc." in order to break out results the way you need. With this dense_rank method I typically accomplish that using regular 'ole WHERE conditions. Of course that's gonna be pretty subjective.

    Replying on in my phone now so limited in how detailed I can be. I can give better examples later if that doesn't make sense.

    Edit: I think it is an Oracle thing. Analytics are one of the areas I will unapologetically use DB-specific functions. Portability be damned! Generally they've been tuned very specifically to solve a problem with the specific engine in mind. Of course that won't always be true, but that's my general thought process.

    1
  • sql
    SQL - any and all Moops 2 months ago 87%
    What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... )

    I had an interesting conversation at work where someone questioned my use of DENSE_RANK and suggested I use LAST_VALUE. We had a good conversation about it, but ultimately agreed to disagree about the specific scenario. My code was accurate with no performance issues warranting a rewrite. My feeling was the person I was talking too was less familiar with DENSE_RANK and so favored LAST_VALUE. I get preference, I have my own, but I try to be aware of what's preference vs. what's technically superior. I'm curious about people's thoughts on when to use LAST_VALUE() vs MAX() KEEP(DENSE_RANK LAST ORDER BY ). To my mind, both solve a similar problem. I lean towards DENSE_RANK largely out of preference due to the syntax being shorter (literally just less characters to type), and I also like that since DENSE_RANK is an aggregate function it outputs distinct results without needing to use the DISTINCT keyword. I haven't intentionally run tests comparing the two, but anecdotally I've never noticed a performance difference between the two when writing comparable queries. Surprisingly I couldn't really find any detailed articles or discussions online comparing these two functions and I'm curious what thoughts are out there in the wild.

    6
    2
    news News Exclusive: Harris leads Trump 44% to 42% in US presidential race, Reuters/Ipsos poll finds
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    And my vote in Oklahoma.....oh fuck it who are we kidding lol. Meaningless. I still do it though.

    29
  • whitepeopletwitter People Twitter What a helpful little kid
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    Ok but like, there was a little sip and flirt on the way wasn't there? ;)

    I kid. Keep on keeping on.

    6
  • games Games Elden Ring’s Igon on Recording His Role in the Erdtree DLC and Meeting Miyazaki: ‘It Was Epic in There’
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    That was actually an interesting read. First one from a game journalist in a while lol. Crazy how much energy they spent on just one, rather small character.

    2
  • linkedinlunatics LinkedinLunatics This will surely stop people making fun of HR
    Jump
    traditional_art Traditional Art The Morning Visitor by Dino Buzzati (1967)
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    2 months ago 100%

    Because not everyone has had the experiences and education we have. Perhaps we should take the opportunity to educate rather than to shame.

    93
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 months ago 100%

    Fake news! Everyone knows it has to be MUCH colder than that to freeze. Not buying your snake oil sir. Good day!

    7
  • linkedinlunatics LinkedinLunatics is this employee in the room with us right now?
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 months ago 75%

    No "/s" necessary. That notation is for lazy writing. If the OP was being sarcastic, it was poorly communicated and deserves the condemnation. Sarcasm's risky. Do it well and it's hilarious. Do it poorly and get flamed. That's the gamble.

    2
  • linkedinlunatics LinkedinLunatics is this employee in the room with us right now?
    Jump
    bloodborne Bloodborne It's like Sony is afraid of making a lot of money
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 months ago 100%

    I feel ya. I've always been a PC guy, and either patiently wait for ports or just don't play games if they never do. Bloodeborne is the only one I can remember really feeling like I'm missing out. Although Imma need them to hurry up on God of War lol.

    1
  • bloodborne Bloodborne It's like Sony is afraid of making a lot of money
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 months ago 100%

    I can't fathom what these companies gain from this. Does anyone really buy a console just to play an exclusive game?

    12
  • patientgamers Patient Gamers It's almost the week-end, what are you guys going to play?
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    3 months ago 100%

    Elden Ring. I decided to go into the DLC with a new character and getting him setup so he's ready to jump in. Gathering smithing stones and other mats, killing Radahn and Mohg, and getting some weapons whenever I finally decide what build I want to start with. Put a couple hours in so far and really enjoying it.

    3
  • technology Technology IRS makes free tax return program permanent and is asking all states to join in 2025. This could deal a massive blow to private tax filing services such as TurboTax
    Jump
    vegan vegan Carnist logic… or lack thereof
    Jump
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearMO
    Moops
    4 months ago 60%

    Rofl, sensitive one huh? Dinner didn't look enough like a hotdog tonight?

    Apparently this is just what you're like. Have fun with it I guess. Blocking your shitty-take profile.

    2
  • historyporn HistoryPorn US Paratroopers with mohawks, prepping for deployment on D-Day, WW2, 1944
    Jump
    "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearSM
    smoking meat Moops 1 year ago 100%
    Had to check that butt out one last time before bed.

    There she is, looking all fine. Had to get one more peek before calling it a night a little early. We have a hot date in the morning.

    2
    0