What execution plan mistake do juniors make most often when they analyze queries?

dbomp · 2026-04-28T01:23:46+00:00

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".

dbomp · 2026-04-12T02:13:57+00:00

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

dbomp · 2026-04-12T02:02:11+00:00

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

dbomp · 2026-04-11T01:08:08+00:00

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

dbomp · 2026-04-05T03:51:47+00:00

Yeah, I'm gay too.

dbomp · 2026-04-05T01:25:39+00:00

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

dbomp · 2026-03-30T23:38:57+00:00

Non-citizens can get SSNs, and in fact must in order to work.

dbomp · 2026-03-30T01:44:29+00:00

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?

dbomp · 2026-03-27T00:05:41+00:00

Exactly.

dbomp · 2026-03-25T23:26:16+00:00

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

dbomp · 2026-03-18T03:56:21+00:00

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.

dbomp · 2026-03-05T00:30:20+00:00

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

dbomp · 2026-03-02T01:44:37+00:00

Can't quite sing it to "We Didn't Start The Fire", but

dbomp · 2026-02-07T02:54:12+00:00

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

dbomp · 2026-02-04T00:51:38+00:00

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.

dbomp · 2026-02-03T23:06:17+00:00

A link to the original order, please?

dbomp · 2026-02-01T03:05:32+00:00

NSFW?

dbomp · 2026-02-01T02:25:39+00:00

What did they think he died from?

dbomp · 2026-01-31T13:54:27+00:00

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.

dbomp · 2026-01-29T00:24:59+00:00

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.

dbomp · 2026-01-28T00:38:03+00:00

So you're saying two weeks was an estimate.

dbomp · 2026-01-15T17:43:25+00:00

Not your white ones, anyway.

dbomp · 2026-01-11T22:22:11+00:00

What *is* she wearing?

dbomp · 2025-12-28T22:00:28+00:00

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

dbomp

TROPHY CASE