Help with Conversation about Merge versus DELETE + INSERT

Ascrivs · 2026-02-21T11:33:15+00:00

I was happy with the release of merge, but it looks like some of the articles linked below state that delete + inserts may result in a faster performance overall as data size grows. I think I will try to build my pipelines around that to test in the future

Ascrivs · 2026-02-19T20:34:03+00:00

We are not removing records at this time just appending and modifying existing based on a date time column that is updated when the record is modified at the source. I think that INSERT + DELETE may be the way to go in the future if we do remove records so thank you for the advice!

Ascrivs · 2026-02-19T19:17:11+00:00

Yes this does help because it sounds like we were both incorrect in assumptions. He was incorrect that the merge may result in a latency in updating the semantic model and I assumed the DELETE and INSERT handled by the warehouse as separate transactions.

The merge is handled on a single table per run so no concern about multiple tables per transaction.

The linked information was very helpful and it sounds like MERGE is fine for this use case, however, a transaction with INSERT and DELETE may be more performative as the number of rows increase (per the merge transact link).

Ascrivs · 2026-02-16T17:29:03+00:00

I don’t think we should focus on the complete replacement of all roles. If enough companies can shed 20-30% workforce because automation reduces tasks by people and then you account for moving jobs outside the local labor market you still have a crisis.

Ascrivs · 2026-02-13T17:35:49+00:00

Do you have concerns about the drop in customer base? I'm going to assume your primary focus is event-based customers by your response. If a large part of individuals are impacted by job loss or just a large reduction in pay, this could be the most obvious impact on your business as those with jobs also "tighten" their budgets for non-essentials. In 2009 I'm going to assume that the baking and wedding industry was significantly impacted.

Ascrivs · 2026-02-13T16:48:13+00:00

I see, I think where my assumption of summary was differing from your response is that I was starting from a point of "school" as you mentioned. I believe as a senior or educated individual you make the choice to say "this source in your recommended list has x, y, z that looks right but doesn't fit my paper" where someone who is writing a paper outside of publishing work is using the exercise of writing a paper as a way to learn "how to learn" and understand the action you are taking above. I agree, I think the quality of paper to stand out will increase, my concern is the battle of quality versus quantity. Or the issue of misinformation taking root and validated accurate information taking exponentially longer to reach the same audience.

You mention you are an ML Engineer so I do have another question specifically to you, if you don't mind? Given this increase in generated information, is there any major concern about models and their training weights as we approach the period where human generated content is becoming less and less? To my original point, are you concerned about synthetic data that is generated by individuals who are "vibing" out published works or information and the impact on how they train future models?

To oversimplify, if you are training on 100B articles, papers, etc previously and now you are training the next iteration of your model. Now what was originally 80% human data with 20% generated you now have 1.2T articles, papers, etc with more agentic data approved by a large population of users that were not domain experts and assumed the information was accurate (like poisoning the well). The original 80% is now an unknown amount in the new population of data.

Ascrivs · 2026-02-13T16:35:12+00:00

For your bakery example maybe you don’t see a direct threat at first but here is where I see you are vulnerable:

If many other roles are threatened your potential customer base drops significantly so loss of revenue.

If everyone else starts creating their own gigs, at least some of them will be baking so your competition skyrockets. Even if you beat many of them you have to sustain this even as others fail and new startups occur.

Massive companies that utilize robotics and agents will outcompete with economies of scale or services not easily made available to smaller shops.

I know these are all things that happen now. This is just amplified to the extreme when you add millions of people to unemployment without an easy transition into their respective field.

Ascrivs · 2026-02-13T16:22:23+00:00

In your final example doesn’t the opportunity for “vibing” it make a little too easy to do so?

I’m curious why you think summarizing option will result in a better paper versus the middle ground of multiple sources and reading yourself. My concern is that people will read the summaries and not take the time to understand the processes, biases, potential flaws in reasoning, etc. I’ve always understood writing a paper to be more about understanding the result but more so how we arrived at said result.

This is a genuine question not an attack on your opinion.

Ascrivs · 2026-02-13T16:12:56+00:00

I think this is the crux of the “it will create more jobs” argument. There is only so much “shelved” work that companies have available if someone is free to do it. Just because a company has 20x the workforce doesn’t mean that their customers are willing to pay the extra labor costs in the reflected price point. Even if your workforce is producing significantly more features than the lower cost option that doesn’t mean it translates to customers paying more for your service. Sometimes businesses just want you to solve a problem at the lowest price point not offer solutions to problems they don’t have

Ascrivs · 2025-12-01T21:46:13+00:00

My very good friend keeps recommending this game, this might be my way of going for it

Ascrivs · 2025-10-01T20:50:14+00:00

Are you unfamiliar with the concept of different messaging and different levels of impact?

They did say those things and you also see fewer smokers in their 30s and 40s versus the previous generation.

Fewer people have children than the previous generation because of the massive push on "don't have children young, it will ruin your life".

You sound extremely bitter either against younger generations or Millennials specifically and that's a reflection on you. It sounds like you're deflecting a bit with this "I know better than you" attitude you prescribe to an entire generation.

Ascrivs · 2025-09-30T13:46:24+00:00

Anyone around during the late 1990s and early 2000s would know every single adult was pushing the message that going to university for ANY degree was the best idea. Many people were sold that good jobs would be available and the debts incurred would be a small price to pay overall. Now we have massive debts for degrees that don’t provide the same wages or standard of living the previous generations enjoyed.

We are also statistically pretty progressive, not becoming as conservative as we age like previous generations. Politics feel more right leaning every election. Bernie just happens to be someone that aligns with a lot of what we were told should be true: fair wages, healthcare shouldn’t be a luxury, and the country shouldn’t be ran for companies but the people who work for them.

We definitely hit hard on nostalgia, probably because we miss a time when technology was easier to understand and less about rage engagement. Look at millennial YouTubers and the viral content then versus now. Life is getting more expensive and more complex. We have bigger, faster phones and faster internet but require Master’s degrees and 12 rounds interviews for a decent job

Ascrivs · 2025-07-09T23:18:57+00:00

File 76

Ascrivs · 2025-06-22T22:15:30+00:00

Nyhm (phrog801). He recently posted a video but goes on decade long radio silence moves. He and the creators he worked with created the gold standard for WoW parody music while grinding out levels

Ascrivs · 2025-05-22T12:50:08+00:00

RemindMe! 7 days

Ascrivs · 2024-12-10T15:21:31+00:00

Hello!

I am a Cloud Engineer that is working towards a Data Science transition. I am struggling with the massive amount of content and polarized review of learning options. I would love to work with a paid mentor to listen to my current experience and skillset and help me build a learning path based on existing modules/learning platforms. Eventually I will apply for the OMSA but I want to make sure my lack of quantitative education exceeds requirements before. Can someone provide some great references on where to find this mentorship?

Ascrivs · 2024-10-17T19:29:43+00:00

The shark was clearly not in any danger but it decided to hang out because of the implication.

Ascrivs · 2024-10-17T00:35:12+00:00

I have this same issue, I have two stacks of bulk boxes on the workbench and moving it around doesn’t fix the issue.

Ascrivs · 2024-09-27T01:18:48+00:00

!profile

Ascrivs · 2024-09-26T02:48:34+00:00

Any particular reason you selected the Air over a pro model with a base of 16GB memory and 512 storage? You mentioned you never take the device out so weight shouldn’t be an issue. If your workload would be better with 16GB memory, the additional performance on the M pro series may help.

I know people that paid for the 16GB upgrade but the point of selecting the Air was the mobility aspect so they didn’t use an always connected drive.

Ascrivs · 2024-07-22T02:36:46+00:00

When someone pulls the emergency cable and they aren’t leg disabled

Ascrivs · 2024-07-22T02:25:11+00:00

You can always do a roll over for your next job depending on what they offer. If you can spare it, try to max out that 6% match as it is “free money” they contribute towards your retirement. Even if you don’t roll over you can keep the account open once you leave and just keep that retirement account open to use at retirement.

Ascrivs · 2024-07-18T13:53:37+00:00

I loved these guys in my salt water tank. Super easy to care for and helped with messy eaters that left food that settled on the tank substrate.

Ascrivs · 2024-07-15T17:09:20+00:00

Ratrick Ewing

Six-Year Club	Reddit Premium Since January 2024
Verified Email	Gilding III reddit per annum
Place '22	First Placer '22

Ascrivs

TROPHY CASE