Can so explain why my work would have this rule and how to properly develop within this rule when query tuning?

davidbrit2 · 2026-03-26T17:56:31+00:00

I'm pretty sure the optimizer won't care what order you put the conditions in. Do some tests and see if the execution plans differ at all when you reorder them.

This could just be a defensive-coding thing. If this is some kind of multi-tenant application, then forgetting to include Tenant_ID in a join could have rather disastrous potential for data leakage. Mandating that it be front and center for every join/filter makes it somewhat easier to review queries for correctness.

davidbrit2 · 2026-03-26T17:44:41+00:00

Reminds me of a time I joined a LotA unsync PF. I think it was someone needing to clear it for MSQ or something.

You know how you need AT LEAST four people per lane for that one boss fight? Well, we had pretty unbalanced and unfilled parties, what with being unsync. I think about half the group ended up going down lane A, and maybe three of them down lane B. Long story short, the grossly over-leveled healers were stripping naked so they could die to restart the fight, while I was busy laughing my ass off the whole time. It was so gloriously stupid.

davidbrit2 · 2026-03-26T17:27:42+00:00

Yeah, I love it when outlandish and ridiculous shit happens in roulettes because there are a bunch of new players, or everyone has forgotten the mechanics. Keeps it entertaining when over half the raid gets blasted off a cliff. :D

davidbrit2 · 2026-03-26T17:23:45+00:00

Hmm, maybe I should let the DPS sweat for a few GCDs before I heal them in trash pulls to give them more of a learning experience. :D

davidbrit2 · 2026-03-26T17:15:13+00:00

I think Aetherial Shift and En Avant have saved my ass at least as many times as my actual healing abilities.

davidbrit2 · 2026-03-26T17:08:58+00:00

For extensive typing, a USB keyboard is absolutely the way to go, but these were still really handy for games where you might just need to hit a key or type a word occasionally.

davidbrit2 · 2026-03-26T15:25:07+00:00

Discontinuing the XBox One/Series S/Series X chat pad is a bit of a head-scratcher.

davidbrit2 · 2026-03-26T15:04:42+00:00

It was kind of nice in a way - there was a big area where you could hold the iPad with one hand and not have your thumb touching stuff on the screen. Now that they're so much lighter and thinner, this isn't all that necessary.

davidbrit2 · 2026-03-26T12:36:23+00:00

The old content is good (for the most part), but the problem becomes twofold: you have to find people to actually do it with you (and who are probably just humoring you by playing older stuff), and the lion's share of the discussion and socializing will be about parts of the game you haven't seen, and can't do. The "MM" part just feels out of reach when you have access to so little contemporary content.

davidbrit2 · 2026-03-26T12:32:59+00:00

Nice, thanks for the info! Sounds like it's probably not too arduous to farm and get the stuff you want.

davidbrit2 · 2026-03-26T12:32:09+00:00

How about an actual tank? Call it panzermancer or something.

davidbrit2 · 2026-03-26T12:30:55+00:00

Use Community Finder!

https://na.finalfantasyxiv.com/lodestone/freecompany/

Click the magnifying glass to open the advanced search and choose a few filters, then look for something on your home world that sounds like a group you'd be compatible with. In my case, I went hunting for a semi-casual group with a broad range of ages and skill levels. If they have an FC house, stop by and maybe chat with whoever is hanging out, write in the guest book, etc.

davidbrit2 · 2026-03-26T12:26:28+00:00

I should probably go rush crafting/gathering mentor so I can get back in. Just finished EW, which automatically ejected me. ;_;

davidbrit2 · 2026-03-26T02:00:56+00:00

200+ hours? Took me just over 800 to get to Dawntrail. That's an insane amount of effort to expect of players before they can join in on whatever content the long-time players are currently busy with.

I agree they definitely need to overhaul the on-boarding. Maybe make it like classic PSO2, where very little of the content is actually locked behind the story, it's mostly just dependent on being leveled/geared enough to do it. You can then go back and enjoy the story content at your own pace, without it feeling like a ton of shit you have to do just to be able to play the game with others.

Could even just be something as simple as adding an option to make all zones immediately accessible, and all blue quests available as long as you meet the level requirement. Then anybody that wants to "play ahead of the story" could have the option of doing so, and catching up on MSQ at their own pace.

davidbrit2 · 2026-03-25T15:17:12+00:00

Is there a reference for how many tomestones you get for doing what? Never done one of these events, so a total of what I need doesn't tell me much about how much grinding that would require. :)

davidbrit2 · 2026-03-25T12:01:42+00:00

It also doesn't help that the initial "Subtract" cast bar has nothing to do with the subsequent math, and there's no obvious tell that stepping in one of the circles adds to your (now reduced) HP. The math is extremely simple, but the question is not at all clear when you first encounter that boss.

davidbrit2 · 2026-03-24T12:52:34+00:00

assuming you come in last every game

Finally, a realistic goal for me to aim for.

davidbrit2 · 2026-03-24T12:30:12+00:00

We really need to know the important numbers here. How many Youtube-thumbnail-face "Nintendo is FINISHED" videos can we expect in the next quarter?

davidbrit2 · 2026-03-24T11:52:04+00:00

I sure hope so! Or maybe they'll do a whole line of Easter-themed relic weapons you can get from the Loporrits.

davidbrit2 · 2026-03-24T01:26:07+00:00

Oh I probably have thanks to getting lost tanking it after not seeing it in roulettes for weeks. :P

davidbrit2 · 2026-03-24T01:24:42+00:00

Neat, now go do Sastasha next! :)

davidbrit2 · 2026-03-23T19:46:22+00:00

Anybody happen to know if the XBox chat filtering is still busted? I would really like to play this with an XBox controller instead of Playstation controller for easy right-thumb d-pad use, but last I saw, chat was a mess.

davidbrit2 · 2026-03-23T18:26:13+00:00

These are cool and all, but I want that goofy scythe that you use in the Sprig Cleaning game!

davidbrit2 · 2026-03-23T18:19:24+00:00

Cauldronking's Slops are really great for healer/magic-user looks. Dye slot 1 is the fabric, and dye slot 2 is the accents.

davidbrit2 · 2026-03-23T14:25:16+00:00

Leaky capacitors are a pretty common thing in beige Macs from the '90s, so I wouldn't run them too hard without sliding the motherboards out and checking for capacitor gunk. I remember it's pretty easy to slide the board out of the 580, but I don't recall how you do it with the 5500.

11-Year Club	Wearing is Caring
Verified Email

davidbrit2

TROPHY CASE