Oh I completely agree.  you should clone to your local disk, not a network share.  And a good way to prove to them that is the way to go -...

I'm not that familiar with RStudio, but I know git and their idea of versioning by folder is something unneeded in git.

In git, the way I would handle it is...

I actually thought the same thing as homebrew01 - when the query completes, the table should go away.  The exception is with temporary tables, which would go away when the...

I did find one way to do this, but it relies on the query still being in the plan cache and is not a very "automated" approach and has potential...

• This reply was modified 4 years, 4 months ago by Mr. Brian Gale. Reason: Updated for more accurate lookups

I was actually just experimenting with this and I am mistaken on how you would find it.

Turns out the plan cache doesn't map this up either... I am going to...

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