See the following article and the link to the other article list in it.

https://blog.sqlauthority.com/2020/06/18/sql-server-queries-waiting-for-memory-grant-performance-tuning/

That will help you provide the proof you need to increase your RAM.

It's worse than that,...

@Ombir ,

I know that the Fill_Gaps table is just a test table here.  What value is returned when you run the following code against the real table?

...

Doesn't SSIS allow you to run a CMD Task where you could issue the following simple DIR command and capture the output to a table?  It'll give you the full...

Thanks for the feedback Grant and Steve!  I really appreciate it.

I don't know what the data is that you're playing that code against.  Is strongly suspect that you may have imported the data incorrectly OR there's an anomaly in the...

Not aware of that, also can't seem to find...

As a bit of a sidebar... I have a visceral hate for DATEFIRST() and @@DATFIRST().  It just bugs me.

With that, and even though it's a tiny bit slower, I use...

Actually, none of the answers are correct (and I didn't click an answer because of that... they're all incorrect).

The first answer is syntactically incorrect because DATEPART only takes two operands.

The...

If you were paying any of us $250 an hour, would you waste our time in such a fashion?  😉

We need to see the stuff that supports what you say...

I put the data in a Table now via bulk Insert, but the query now is failing...

Msg 537, Level 16, State 3, Line 5 Invalid length parameter passed to...

@jeff Moden

I have a fiber outage at the moment, so was unable to catch your Group By session on GUIDS V.S. FRAGMENTATION last night.

Is there perhaps a recording of...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've stopped...

Oh, don't get me wrong... I quite agree that the data isn't "mine".  It belongs to the company.  And your point about responsibility is exactly what I'm getting at.  I'm...

I'm not a Windows kinda guy but couldn't you make it so the server is in a different (private) domain that none of the local admins can't even get into? ...