This reminds me of the good ol' days on these forums... thanks for the memories, folks.

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
   ...

IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind any missing...

My opinion though - SQL Server and xp_cmdshell is an odd tool to use for downloading files from sharepoint... Powershell is a much better way to do it in...

I have a Job running a Maintenence Plan. The plan performs the Backup Database, Check database Integrity, Maintenence Cleanup and Reorganise Index tasks. Occasionally the Reorganise Index task fails...

I don't use Rubrik but any decent tool will turn off the "A" (archive)...

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...