According to your query, you're returning 22 million rows to the screen...

Question:  What makes you think that's going to be fast?  ...

That's great but without the book, the uncommented code you posted doesn't explain at all what the code is supposed to be teaching.

A serious word of caution on the use of PAGE compression...  If you're into doing any index maintenance, PAGE compression will nearly double the time and CPU it takes.  You...

It's just a select from 3 tables, and 2 of them are with left join. For aggregations, I would have done it on SQL Server side. Now I...

Is your "report" going to return all 600 Thousand "records" or is it going do some form of aggregation?

Heh... AI being "confidently incorrect"... Imagine that. 😛

To repeat the question that Phil asked but in different words....

You say something would "return error".  Please copy and post that error.

The following will do it without anything "fancy" that might not work in Oracle, which I've almost totally forgotten about.

   WITH
cteMinCustNbr AS
(--==== Calculate the minimum...

BWAAA-HAAA-HAAA!!! "IT DEPENDS".

https://en.wikipedia.org/wiki/Leap_second

I actually just realised PIVOT isn't working when Multiple rows are present  Putting a fake aggregation such as MAX isn't working as expected.

I'm stumped 🙁

Any ideas, to point me...

Same to you and yours, Steve.  And Merry Christmas to everyone.  This is a well deserved 4 day weekend for me.  Next weekend is, as well.

Update.  We migrated from 2016 Enterprise Edition to 2022 Enterprise Edition.  Virtually everything is run 30-40% slower.  I also did some simple tests between 2017 and 2022 on the same...

The following isn't dependent on DATEFIRST at all.

DECLARE @AnyYear INT = 2023;
 SELECT  ThanksGiving = v1.TG
        ,BlackFriday  =...

I agree... for the OP, I've not had to work with Linux nor containers.

Hopefully, this will be a nice "bump" to get someone that has to take a look at...

Yep.  Understood.  All I'm saying is that too many people think that xp_CmdShell isn't...