Are the table names consistent?  What I mean is are they always the same 8 hex characters?  If so, then you could use a tool like SQL Search (RedGate free...

I think this is possible but messy and mildly risky.  Mildly risky as you would need to use dynamic SQL and there is a chance you could lock out an...

Going back to the IIF approach, could you not do something like:

=IIf(Parameter!ProviderID.Value = 1, 'A,B', 
  IIf(Parameter!ProviderID.Value = 2, 'B,C', 
    IIf(Parameter!ProviderID.Value =...

That is just telling you that you need more memory to store query plans OR you need fewer unique query plans running against the instance.  With the most of your...

I just wanted to second Ant-Green's statement about buying a tool.  SQL Monitoring tools are a must for any SQL instance you care about.

And his statement about checking the logs...

First, I'd recommend posting some DDL so we can consume your data and do some tests.  Nothing worse than untested code, right?

Looking at the image, a potential solution would be...

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