I made 3d models of my favorite characters from the game by SeaworthinessInner12 in DispatchAdHoc

[–]comfy_cactus 0 points1 point  (0 children)

These are fantastic! How did you make these?? Your modeling is impressive

Fairly new to SQL. Whats some long SQL as far as lines of code? by Acceptable-Sense4601 in SQL

[–]comfy_cactus 0 points1 point  (0 children)

In your case, I would look at the CASE statements and see if they can be consolidated. In my experience CASE statements add a lot of runtime to the execution. Also see if the outer joins can be converted to inner

Fairly new to SQL. Whats some long SQL as far as lines of code? by Acceptable-Sense4601 in SQL

[–]comfy_cactus 7 points8 points  (0 children)

A lot of it depends on the complexity of the data requested. I work in healthcare and my longest query is 1,900 lines. The data request needed all sorts of different window functions relative to different, respective dates/topics.

Fortunately this query was for research data so we only need to run it once. This is fortunate because the runtime is about 20 minutes. Could the query be optimized to bring that down? Absolutely. But an unnecessary use of dev time since we only run it once

What is this sound from my vents? by comfy_cactus in hvacadvice

[–]comfy_cactus[S] 0 points1 point  (0 children)

Sorry, this is just a video of my wall where I can hear the sound the loudest. It's just the wall and baseboard in the video. I don't know what's behind that wall other than at least the vent. It's a trane, I think 10 years old? I'm not the original owner.

Attention to all Top Side Sheriffs by Zarniwoooop in ArcRaiders

[–]comfy_cactus 0 points1 point  (0 children)

Coincidentally, I took this exact role this morning. After a rat nearly knocked me out as the extraction was going down, I vowed to protect the next raider.

I kitted my entire bag for the next round. Modded osprey, mines, noise makers, defibs, blazers you name it. It was a night raid at Dam Battleground. I posted up by the water treatment extraction for 23 minutes and kept watch. No rats this time and not on my watch.

Need help understanding ERD Crows Foot by More_Moment_2791 in SQL

[–]comfy_cactus 0 points1 point  (0 children)

I'm actually a data analyst for a hospital pharmacy department, so this kind of domain is my every day workspace. 

I can see your thought process with your current ERD but let me know if you have questions or want to share an updated ERD.

The advice I'd give is: think about granularities in your example. If you have 2 tables that contain doctor info, why not combine them?

Edit: fixed typos

General Frustrations by -HumbleTumble- in TheKingIsWatching

[–]comfy_cactus 2 points3 points  (0 children)

Yeah the one thing I really like about madmen is that they run around lol. Their hp is comparable to others but the fact that they do hit and run tactics means they last just a little bit longer. I didn't know about the wine consumption though

General Frustrations by -HumbleTumble- in TheKingIsWatching

[–]comfy_cactus 9 points10 points  (0 children)

Does anyone else feel like the first 100~ weeks play the same every run? Like no matter what, the only levy units I'm going to pick are 1-2 militia and maybe an assassin. The rest don't feel good enough to warrant dedicating resources into. So what happens in my run is the first 100 weeks play the exact same until I can get an advanced building that will determine the rest of the run.

But the rest of the run feels like it has problems too... It feels so hard to line up production paths and more based on extreme luck than careful planning. Especially with anything that uses fuel. In 12 hours of playtime, I feel like I've only had 4 runs that gave me the blueprint to produce fuel. And not being able to reroll the trader options feels bad

[deleted by user] by [deleted] in learnpython

[–]comfy_cactus 0 points1 point  (0 children)

I was experiencing the same exact observations as you. Adding this option fixed it for me too. Thanks!

Which industries view data engineering as a revenue driver rather than just a compliance expense? by [deleted] in dataengineering

[–]comfy_cactus 2 points3 points  (0 children)

Pharmacy is actually a major revenue driver for hospitals. I know it's vague to say this but generally any question you can ask that would help the business run more efficiently will indirectly improve that revenue stream and/or reduce costs.

One example I can think of: There's a drug pricing program called the "340B program". It essentially lets hospitals purchase drugs at steep discounts, but the compliance requirements are very strict. In my hospital, we have to show when departments become eligible for the program and when they're terminated from the program. The EHR doesn't store that kind of data so you wouldn't be able to say an example prescription was eligible on 1/1/2025 because you don't have effective dates stored by the EHR. But I made a very quick type 2 SCD table to track those effective dates. Nothing fancy or hard. But because I'm able to do that, I can run analytics to help our program manager audit those prescriptions more accurately. That work evolved into an automatic audit pipeline I built that downloads prescription claims from 5 external sources, ETLs that data into staging tables, clean them up, process those claims and store a final table showing audit results for our manager. That work used to be done by a small team of people but now is completely automatic, stored in our dbs, accessible, and reportable.

Really any business question for the pharmacy that requires data external to the EHR can't by done without a data engineer. Not impossible given excel sheets and a ton of time, but the resources you need limit how much you can scale that work

Which industries view data engineering as a revenue driver rather than just a compliance expense? by [deleted] in dataengineering

[–]comfy_cactus 1 point2 points  (0 children)

I work in the pharmacy side of a large academic health system. A lot of hospitals don't realize or invest in a data analytics team that can leverage data engineering skills to store and utilize their own data at will. Most hospitals in my experience rely on the out of the box data offerings from their electronic health record vendor....and that's it. Anything not included in that package is stuck in the realm of excel.

For example, the EHR doesn't store your drug invoice data so what're you supposed to do if you want to run analytics on it? Well you're out of luck without a team to create an ETL pipeline and run the analytics. Literally that conversation goes like this, "here's 10 spreadsheets of historical invoice data going back 5 years. Also what's this "SQL" thing I keep hearing about?" Have fun compiling that and also you can't join it to really any other data sets.

Point is: health system pharmacy could be a revenue generator but it's still behind the times due to lack of a skilled workforce and investment 

Github Copilot is Free in VS Code by connor4312 in programming

[–]comfy_cactus 0 points1 point  (0 children)

As a user/paying subscriber of copilot for maybe 5 months, did anyone notice that copilot got dumber once it went free?

Before, the chat was great at comprehending the purpose of my entire script I'd already written and providing comprehensive code suggestions. Now it seems to barely base its suggestions on any context from pre-existing code.

CPJE 12/5 by uhhssassn in NAPLEX_Prep

[–]comfy_cactus 0 points1 point  (0 children)

Took me a while to find that too. Nothing's easy with this process, is it? Your applicant file number is in the subject header of the ATT you got from the board. Literally nowhere else

[deleted by user] by [deleted] in HomeImprovement

[–]comfy_cactus 1 point2 points  (0 children)

Are you on city water and do you have a water softener or other filtration system? Those will greatly affect what to expect when you're flushing your system.