It might not hurt to reach out to Vormetric as well.  It is a paid tool, so might as well get their support.

From my experience, once corruption happens, unless I...

I think your problem is with your WHEN statements.  Let us look at the first one:

WHEN CAST(CONCAT(CREATE_DATE, ' ', CREATE_TIME) AS DATETIME) BETWEEN
dateadd(hh, 15, dateadd(dd, -1, convert(datetime,...

I agree... there isn't much to go on.

Having an execution plan and DDL would definitely help us help you.  Without that, it is impossible to know what would help.  Adding...

An alternate solution that doesn't rely on the DelimitedSplit8K:

WITH [SampleData2] ([PERSONNUM], [ORGPATHTXT])
AS
(
SELECT
231089
, './Company/20-00001/120---30-00006/40-00506/50-99506/60-29145/97455001/0097455001/Fire-Grill'
UNION ALL
SELECT
121564
, './Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/68990001/0068990001/Location3/Burger-Cook'
UNION ALL
SELECT
999998
, './Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/77990993/0077990993/Location6/Food-Worker'
)
 , [sampledata3] ([PERSONNUM], [ORGPATHTXT], [NoLocation], [ContainsLocation])
AS
(
SELECT
[SampleData2].[PERSONNUM]
, [SampleData2].[ORGPATHTXT]
, REPLACE( [SampleData2].[ORGPATHTXT]
 ,...

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