the best way is to use openquery (use dynamic SQL if required to pass filtering parameters) and convert all numbers and dates to strings on source - if required...

IMHO, the only "actual competitor" is ... the people writing the code.

If they not so good at SQL Server, the code is going to be slow.  What makes you think...

Just to ask the question, have you tried running the database in the 2019 Comparability Level to see if that fixes the issue?

Like I said 😉 ...

You could/should setup an Extended Event to capture anything (including code) that makes the log file grow.  Of course, you'd have to shrink the log...

What I'm actually suggesting is to avoid all sorts of problems.  You have a process that you want to "throttle" because it uses a lot of resources.  Consider what that...

IMHO (and a tiny bit of experience more than a decade ago), it would be more effective to have the Oracle side do the necessary "cube prep" and export the...

Sorry...

Here's how we'll do it:

1. Create a Date List: First up, we're going to make a list of dates. This list starts from the earliest start date of all...

Is...

You could/should setup an Extended Event to capture anything (including code) that makes the log file grow.  Of course, you'd have to shrink the log file to a reasonable size...

You could/should setup an Extended Event to capture anything (including code) that makes the log file grow.  Of course, you'd have to shrink the log file to a reasonable size...

If I'm thinking the same way as you, just use SUM on each column with a GROUP BY on what you have in the left-most column.

Also, this isn't your first...

Sorry... not seeing any "sample...

Bumping the previous post so that it actually shows up because of the "first post on a page" problem they haven't fixed on this forum yet. 🙁

Yep, that's what I was thinking about. Thanks for clarifying! 🙂

I've had my head embedded in Postgres for the last few years. It's not surprising something got pushed out...