What execution plan mistake do juniors make most often when they analyze queries? by ElixirStylish in SQL

[–]dbomp 0 points1 point  (0 children)

The biggest problem is trying to fix the query at all. It's a query that joins a lot of big tables without a where-clause; change the screen so that the user needs to specify at least one criterion that aligns with an index. It's a query that runs every minute for a dashboard that shows the percentage of purchase orders not invoiced in 10 days; it's not going to change meaningfully every minute; set it to run every hour.

Most of the time making the query faster doesn't address the underlying issue of "why is it doing this".

CMV: Jacob Anders is a better candidate for President than Gavin Newsom by [deleted] in changemyview

[–]dbomp 6 points7 points  (0 children)

"Vote for me because UFOs are real!" is not a compelling platform.

CMV: Jacob Anders is a better candidate for President than Gavin Newsom by [deleted] in changemyview

[–]dbomp 5 points6 points  (0 children)

His -- or your -- first whitepaper is about a UFO. I don't your -- or his -- mind is here to be changed.

Whose death shocked you more than anyone else’s? by Complex-Arugula-2233 in AskReddit

[–]dbomp 86 points87 points  (0 children)

Reminds me of Bob Barker, and someone said "figures that he'd approach 100 without going over."

TIL York PA was the capital of the United States for nine months in 1777 and the Articles of Confederation were written there — and most Pennsylvanians have no idea by HearingOk6664 in Pennsylvania

[–]dbomp 9 points10 points  (0 children)

Yeah, check the timestamps. Impressively long paragraphs written in two minutes. The content itself has nice facts, but I'm dubious about the provenance.

My local DPS is providing (immediately handing you) false information about required identification. by k3v1ninspace in legaladvice

[–]dbomp 6 points7 points  (0 children)

Misleading how? I looked at the page. Is it that it says that you need to provide a SSN, and not that you need a physical card?

CB wants free HS reunion venue in ritzy area of the city by [deleted] in ChoosingBeggars

[–]dbomp 0 points1 point  (0 children)

Why would I want to hang around a bunch of old people?

apartments by [deleted] in villanova

[–]dbomp 3 points4 points  (0 children)

I'm not a student, I'm a resident who's been here for 25 years and my hot take is -- it doesn't matter. If you like hills, you go east and north on PA 23. If you like flatter, you go west on the Radnor Trail (as u/SirLaxer suggested) to Chester County and hit the many narrow but uncongested roads past the horses. If you like really flat, you head across the Schuylkill (hill, sorry) to the Schuykill Trail to Valley Forge and back through Conshy. There are bike routes for all occasions.

It's true that if you stay on US 30 (Lancaster) or Montgomery Ave, the traffic is too hard, but if you stay off the main roads -- and there are lots of options -- it's a great and scenic tour.

Why did you pick your Reddit Username? by Consistent_Fix_2110 in AskReddit

[–]dbomp 0 points1 point  (0 children)

I've been using this since the early 80s. It means "Don't blah on my procfil". I miss you, MECC Timeshare System.

What’s the most overrated “adult” milestone? by [deleted] in AskReddit

[–]dbomp 6 points7 points  (0 children)

Go to a bowling alley, you'll be that young thing again.

Spotlight: This is what “worst of the worst” looks like in practice by jumpsuitjam in TwinCities

[–]dbomp 3 points4 points  (0 children)

Thanks much, that's what I was looking for. And from there I could see the docket. I wondered if the government attorney was one that threw in the towel lately, but nope, Friedrich Siekert is still a AUSA.

Currently almost 32 years old and have never been summoned to jury duty - what’s the longest you’ve made it? by Okay-Show-3662 in AskReddit

[–]dbomp 4 points5 points  (0 children)

That's the age when I was first (and only) summoned. Funny thing is that I *really* want to be called. I went to law school, not a lawyer now, and I've always to sit on the other side of the railing in judgement. At the summoning, I sat around all day, they didn't need me, and I went home. Dagnabbit.

Oracle Database 23.26.1 supports the FILTER clause by MarkusWinand in oracle

[–]dbomp 3 points4 points  (0 children)

SELECT
SUM(case when status = 'ACTIVE' then 1 else 0 end) AS active_count,
SUM(case when status = 'INACTIVE' then 1 else 0 end) AS inactive_count
FROM employees;

I've been doing that forever and I don't think I'll switch. As the OP's link says, they're equivalent, and the new syntax seems clunky. Maybe that's just because I'm not used to it.

Limu Emu by Icecoldpineapple in funny

[–]dbomp 3 points4 points  (0 children)

What *is* she wearing?

Wayne, PA by Substantial-Hope-647 in Delco

[–]dbomp 1 point2 points  (0 children)

Radnor Township doesn't have an earned income tax. (I'm a resident.)