Thank you, Phil - the execution plan is the same. And same as with my tally table, 94% of it goes on INSERT INTO @t table

Thank you, Jeff.

Much appreciated.

1. Only #temp or ##temp tables.

2. Yes

3. Sadly no.

Massive thanks.

Thank you, Jeff. The real data will have various reasons, but I need to exclude only three out of the rest.

I can confirm now the pipe (|) can be added...

• This reply was modified 1 year, 5 months ago by  BOR15K.

Very valid point. No, there is no separator, but after having an internal chat, it may be possible to add a pipe (|) as a separator.

Thank you for the reply, yet I think it will not work if the reason column, as I mentioned in my original request, will have several concatenated reasons.

Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part...

Does the antivirus software you use have a CLI?

You could write a script task in C#, VB.Net to interact with your AV and call it to scan the file...

Please be specific as to what kind of blocking occurs and how long it actually lasts.

Then, let's see some proof...

Please be specific as to what kind of blocking occurs and how long it actually lasts.

Then, let's see some proof or an...

The DBA's right about the concurrency issue.  Also, you should really only create a clustered index on a temp table and it should be created before the table is...

The DBA's right about the concurrency issue.  Also, you should really only create a clustered index on a temp table and it should be created before the table is...

I have got your point.

I have removed the dates related part from WHERE...

Wasn't it obvious....  THANK YOU!

Thank you, Jeff

It was extremely helpful article.