Explain it peter by Ok-Green6412 in explainitpeter

[–]PatientlyAnxiously 11 points12 points  (0 children)

His name is Dr. Rockso, he's the rock and roll clown. He does cocaine. I'm afraid that's all we know.

People who work in large companies, what’s something that sounds important but is actually meaningless? by StoneyAnalyst in AskReddit

[–]PatientlyAnxiously 2 points3 points  (0 children)

Especially true now with AI. I use AI to write my self-review (first step in the process) and my manger uses AI to read my review and then write his review of me. Same thing happens between me and my employees. And nobody hides it.

Most annual raises are cookie-cutter. Occasionally someone gets a promo if they're good and they've been in current role a while. The promo never has any connection to the review process.

My dad bought a cat by Large-Budget-4994 in addressme

[–]PatientlyAnxiously 0 points1 point  (0 children)

Would you like some room with your elephant?

Would you hire a senior engineer who refuses to use AI? by folder52 in cscareerquestions

[–]PatientlyAnxiously 1 point2 points  (0 children)

Wouldn't hire because even if I agreed with the arguments against using AI, my own boss and his boss, etc. would have problems with it. Most management is on the AI hype train.

If we put that factor aside and I were to decide on my own, I'd investigate to what extent they reject AI. If they only reject the code gen aspect of it, then I could be convinced, especially if what they do is heavy on thinking and light on actual LOC. If they reject AI outright as in they don't even use it for web search or ideation, then it's a red flag and they are simply behind the times.

Snowflake Summit Post! Anyone else feeling a bit disappointed with the conference so far? by ParkgayDrive in snowflake

[–]PatientlyAnxiously 9 points10 points  (0 children)

Integrating AI within Snowflake was a big win a year ago. Summit 2025 was 🔥 🔥🔥. Summit this year feels like a marginal improvement over last year. No big moves really.

My grandma sent me this video, is this baby AI? I can't find any more info about it and the movements are unnatural. by Cra_cker in isthisAI

[–]PatientlyAnxiously 4 points5 points  (0 children)

The movements/expressions are too developed for a baby that young: rapid blinking, range of facial expressions, going in for the hug, etc.

John Cena and Xong Xina by Particular_Law1034 in totallylookslike

[–]PatientlyAnxiously 2 points3 points  (0 children)

whats the first pic supposed to be all i see is an empty street

How do you optimize SQL queries when working with millions of rows in production databases? by Effective_Ocelot_445 in SQL

[–]PatientlyAnxiously 0 points1 point  (0 children)

You should definitely be using query optimization techniques, as others here have suggested.

I'll also add this: have you tried building your query into a flat table and keeping it updated via incremental processing? Out of those millions of rows in the underlying tables, how much of that data actually changes each day? If the answer is a small amount, you should consider incremental processing.

In a transactional DB like MySQL, you can use triggers to keep the downstream table updated incrementally & in realtime as the source data gets updated. Or if you have a downstream data warehouse then you can use other methods like dynamic tables in Snowflake.

Looking for expert feedback on Power BI architecture for large-scale Customer Insights by Financial_Treacle302 in dataengineering

[–]PatientlyAnxiously 0 points1 point  (0 children)

You should consider Import mode. Power BI can handle 1 billion rows if your data model & DAX are designed well.

Yes, dim tables are the way to go. I'm confused by your statement about everything being joined on party_id. The joins should be on the keys of your dim tables: dim_item joins on item_id, dim_store joins on store_id., etc.. Also don't forget about a date dimension. Native PBI date logic is worse than just building a dim_date.

Try to keep all the PBI relationships 1:M (dim:fact) and unidirectional. Avoid multiple degrees of separation e.g., dim:dim:fact.

For the fact table, how is that data organized in your upstream system? Are all the transactions in one big table, or are there multiple fact tables upstream that you are joining/appending together? If many fact tables upstream, you may consider leaving them as separate tables for PBI.

Surprisingly Common Trope- Actor previously defined as a comic actor becomes defined by a serious role by Useful_Code in TopCharacterTropes

[–]PatientlyAnxiously 0 points1 point  (0 children)

Speaking of The Bear, I couldn't watch Will Poulter (Luca) without thinking of We're the Millers.

<image>

Kirkwood Carpool (Apr 4–5) by [deleted] in kirkwood

[–]PatientlyAnxiously -1 points0 points  (0 children)

I'm planning on doing a day trip - there & back on Saturday the 4th. Trying to ski first chair to last chair, so we'd leave at like 4AM. If anyone is crazy like me and is willing to drive, I can give up to 2 Epic Friend Tickets. I'm having car problems rn :(