Yes, my approach will filter the whole data set.  If you need it filtered in just one place, then my suggestion won't help you and will actually make things worse.

I like the approach that everyone else is offering, but thought I'd chime in to describe mine in a bit more detail.

My suggestion was to change the data source from...

See https://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statistics-options/#:~:text=%20The%20auto%20update%20statistics%20feature%20can%20be,INDEX%20statement.%20You%20can%20re-enable%20the...%20More%20

Specifically this section which indicates what triggers an auto-update on the statistics:

- There was a data change on an empty table.

- The number of rows in the table was...

I think that is the joys of the SQL engine.  USUALLY logical reads are slow operations and having more of them will result in longer elapsed time.  That is likely...

As a thought on this, as you can't push this to the stored procedure, what about if you push it to the TSQL?

What I mean is in the SSRS package,...

Another thing to check is linked servers.  If a linked server connection connects to that instance as a user who has permission to drop and create objects AND you have...

Experts correct me if I am wrong, but what I am seeing is that you have no filter predicates on the non-clustered index scan.  The filter is on the clustered...

I think the first step is finding the right tool for the job.  For doing analytics, I would recommend an analytics reporting tool (SAS Visual Analytics, PowerBI, Excel, Tableau, etc). ...

As a thought - what about instead of trying to build the data set up to contain all possible combinations of summing up the data, you do it in the...

Like TangoVictor, all of my stuff is on-prem as well, so my tips and advice may be useless.

Things I'd check (if possible) are logs on the server.  I'm thinking that...

I agree 100% with latkinson above.  I know when I attended my first PASS Summit I was VERY new as a DBA and all my learning was from google and...

I agree with Jeff here on not using a bat file for this UNLESS you are on SQL Express.  If you are on SQL Standard or higher, then I would...

I see 2 potential options here:

1 - contact WooCommerce to see if they can fix their data export to be in proper JSON format

2 - parse the text before importing...

Pretty sure that query store isn't going to help you there.  Query store is for storing execution plan statistics and it auto-flushes itself depending on the configuration you have set.

What...

My opinion - either can do the install, but the DBA needs to do the configuration.  The Server team should be able to handle an install as long as you...