Moops 21 hours ago • 100%
I am both the leaf, and the fruit flies who copulate on it.
Moops 3 days ago • 100%
Smithereens you say!? Tell me more.
Moops 3 weeks ago • 100%
Well I don't know about you guys, but I sure am convinced.
Moops 3 weeks ago • 66%
The vegans an angry, toxic bunch lol
Moops 3 weeks ago • 42%
They're so small and adorable aren't they?
Moops 3 weeks ago • 100%
Aww shit. Thanks lol.
Moops 3 weeks ago • 50%
Of course it was the vegans.
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.
Moops 4 weeks ago • 100%
It really is such a perfect juxtaposition of toxic vs. healthy masculinity.
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".
Moops 4 weeks ago • 100%
You're a moron and I'm sorry for your failed upbringing.
Moops 1 month ago • 100%
This looks like my ex. I'm not even tryna be mean, it just does.
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.
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.
Moops 2 months ago • 100%
What a weird little man.
Moops 2 months ago • 100%
That headline is a wild ride
Moops 2 months ago • 100%
Why would someone go about building ruins? Wouldn't you want an actual building with walls and a roof?
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.
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.
Moops 2 months ago • 100%
And my vote in Oklahoma.....oh fuck it who are we kidding lol. Meaningless. I still do it though.
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.
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.
Moops 2 months ago • 100%
For when you want to watch someone go fuck themselves...
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.
Moops 3 months ago • 100%
Burn the witch!
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!
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.
Moops 3 months ago • 100%
What do you envision "high quality human contact" to be?
Moops 3 months ago • 100%
Lol. I'll wear that tin foil hat with you.
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.
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?
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.
Moops 4 months ago • 91%
Some are those that work forces...
Moops 4 months ago • 100%
Woooooo!
Moops 4 months ago • 91%
This is clearly a joke.
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.
Moops 4 months ago • 100%
Shit, we forgot to call EMS didn't we?
Moops 4 months ago • 100%
Felt fine to me ;)
Moops 4 months ago • 100%
Knew it! I love that electrician and his story telling.
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.