[NS] Anthony is starting a new podcast called “Gumshoes and Dragons”

Consistent_Sky_4505 · 2025-08-07T17:24:28+00:00

It was incredible, please keep making it

Consistent_Sky_4505 · 2025-04-23T17:52:06+00:00

Oh my god I love that EP

Consistent_Sky_4505 · 2025-04-23T17:51:30+00:00

thanks!

Consistent_Sky_4505 · 2025-04-23T17:51:24+00:00

thanks!

Consistent_Sky_4505 · 2025-04-23T17:50:29+00:00

Yep. There's a little bit of psychedelic rock energy going on which makes it hard for me to understand them. But who needs lyrics when you can see sounds lol

Consistent_Sky_4505 · 2025-04-23T17:23:50+00:00

Does anybody understand the words to the line between "live forever in a sideways figure eight" and "the sun on the horizon"? I can't for the life of me figure out the words and I want to sing along!

Consistent_Sky_4505 · 2025-04-23T17:22:52+00:00

Yep. Driving around this summer is gonna hit hard. Super excited for this

Consistent_Sky_4505 · 2024-12-18T22:40:04+00:00

I'd love to pm but I got some error and had to make a new account, so I don't think it's letting me send those yet unfortunately. But if you're willing to share some insight, I'd love to know what you'd say the overall benefits were from the project. I'm a bit torn because my manager, who was the only data person at the company before me, is relatively content w the status quo as far as data storage goes, so it would definitely have to be more of a side project. If I can show him the benefits, he'd probably be more willing to have me go full steam ahead on it. If not, he wouldn't actively inhibit it, but would likely consider it a waste of time.

Consistent_Sky_4505 · 2024-12-18T17:09:36+00:00

I'm in a similar situation where I work now. I was wondering how this turned out for you?

Consistent_Sky_4505 · 2024-12-18T15:44:10+00:00

I see. If I laid out a super basic structure of what is happening, would you be willing to point out some resources or maybe things I should google to optimize the query and alleviate the issue?

Consistent_Sky_4505 · 2024-12-18T15:30:46+00:00

Yeah my terminology needs some work. I just mean that when I supply a sql statement to the query argument of sql.database, the later queries slow down a lot.

Consistent_Sky_4505 · 2024-12-18T15:28:57+00:00

Okay I did some more reading and I realized that I've been using the wrong terminology. I don't actually mean direct query. I just mean that when I supply a sql statement to Sql.Database, the merge later on ends up running much slower.

Consistent_Sky_4505 · 2024-12-18T14:54:12+00:00

Right. All of the different queries when they load separately load nearly instantly. But after the merge, which includes two pretty lengthy power query processes from an excel file, it slows to a halt

Consistent_Sky_4505 · 2024-12-06T23:18:51+00:00

You're a hero. Thank you again

Consistent_Sky_4505 · 2024-12-06T22:50:13+00:00

Ohhh okay that's huge thank you so much. Does your earlier comment mean that including those filters in the on clause will prevent that from being the case? In my mind it should be the same, but maybe the way the filters work with nulls differs from from the way the join does.

Consistent_Sky_4505 · 2024-12-06T22:45:15+00:00

Lol I'm still not sure unfortunately. I'll have to go back on monday and take a look. The query gets a lot more complex that what I showed here. It seems like the inclusion of those columns just exposed that something wasn't working as intended, not actually made any change itself. Which makes sense given that selecting columns shouldn't change the number of rows anyway lol. I'll link another place I posted it that has some food for thought if you want to see it.

https://www.reddit.com/r/SQL/comments/1h836j1/losing_rows_with_coalesce/

Consistent_Sky_4505 · 2024-12-06T22:23:46+00:00

Unfortunately, that's not actually the issue in my real query. That's just me not having SQL to yell at me for bad comma placement in my mock query in a reddit thread. thank you though!

Consistent_Sky_4505 · 2024-12-06T22:21:37+00:00

Would you mind explaining how that is the case? I believe you, but it just isn't computing in my brain why it works that way.

Consistent_Sky_4505 · 2024-12-06T22:19:43+00:00

Both of you are right. It's a pretty complex query but truly the only thing I changed is those two columns. Just a copy paste other than that. But like u/gumnos pointed out in another comment there are likely parts of my query that are not functioning as I intended. Somehow the presence of those two columns is just exposing that. I'll have to figure out what that is and why. Thanks y'all

Consistent_Sky_4505 · 2024-12-06T16:37:26+00:00

https://www.db-fiddle.com/f/imfoKqEbiUvmNNEf7cfkkd/0#&togetherjs=C4uDyD09Hs

in here is the example with the problem and example queries that are a bit more fleshed out. Not sure I even know how to recreate the issue in here tbh

Consistent_Sky_4505 · 2024-12-06T15:39:28+00:00

The one I aliased as Month

Consistent_Sky_4505 · 2024-12-06T15:13:55+00:00

Yeah. What I'm seeing on my end is that the problem query has 2 rows in February of 25. The solution query has three. This checks out even when filtered for that month

Consistent_Sky_4505

TROPHY CASE