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

My understanding is that they are 2 completely different data capture methods.  Ring buffer is a buffer and only exists in memory.  The advantage to this is that you are...

Pretty sure for this to work you are either going to need to have your stored procedure call a second stored procedure (likely the approach I would go with) OR...

I updated my post as the forum apparently didn't like the alias I used.

Since you are updating everything and you are doing it every 24 hours, I would recommend trying...

I would start development on this by making it work with a SELECT statement, which you can do with 2 JOINs.  The basic logic of it is you want to...

• This reply was modified 4 years, 4 months ago by Mr. Brian Gale.