I agree, it doesn't work well for a room that's used as a storage for messages migrated from elsewhere. I guess initially the devs expected people only to chat in chat rooms. I know, ridiculous!
I can't use <some>DB, Consumer Reports says the seek performance is a half Circle
Me: "Surely, joining to the same tables 4 times must be slower than joining once and aggregating" Narrator: It was not
I was thinking: "Gee, everything should be on the same page, just read it once!" and this is again where I learn the lesson of "joins are less expensive than reading more rows"
"Efficient" method: clustered index seek: reads 27 million rows (out of 420 million). "Inefficient": reads 206K rows 4 times.
I think the tax credit is capped at two now? Hard to follow since the tax plan went sort of off the rails. I do know we'll get stimulus money for the youngest when we file.
I wonder if simply pointing at https://dba.stackexchange.com/help/minimal-reproducible-example would be helpful.
From that page:
provide the SQL scripts so others don't have to recreate them. Do not provide screenshots of tables or results.
@MaxVernon i think lack-of-repro and and screencaps-instead-of-text are two distinct problems. certainly there's a lot of overlap in occurrence and symptom, but i don't think the people who need the information are served by compressing the guidance down into a single page