Yes, in theory could be less efficient in some cases than a LOOP join.  But it's still reasonable performance.  You'll never totally drop off a performance cliff going from...

Looking at the two plans, it seems that the TOP 1 version tries to avoid the sort.   (With disastrous results.)    Apparently it can read the correct sequence from...

Well, I was thinking of replacing the entire JOIN clause with WHERE P.EvidenceLetter In('J') [or In('J','K','L')]  and so on. I tried that in my initial tests, and it also made...

BTW, the TVF does not always have only one record. Usually one, but it is possible to have almost 50. However, that would be an extreme case, and probably an...

It also doesn't matter where I put the HASH directive. Both of these work fine, and yield what looks to be the same execution plan:

INNER JOIN RO.fntStringsToTable...

Yep, that did it. Inner HASH Join, instead of Inner Join, and the query runs normally. The execution plan is still slightly more convoluted than without the Top clause, but...

• This reply was modified 5 years, 3 months ago by pdanes.

GOT IT!!! Finally - this site had all the necessary details in one place.

https://www.mssqltips.com/sqlservertip/2143/creating-a-sql-server-proxy-account-to-run-xpcmdshell/

If the app gets changes, then an upload is immediately correct. You said that a job doesn't work because it could take a minute to show changes, but those...

If the app loads this, why do you need the dir command? Don't you know where attachments are stored? If you use Filetable, you'll have a known share (\\server\share\path\file)....

1. Filetable is the evolution of filestream that includes a share that is accessible like any other share. https://docs.microsoft.com/en-us/sql/relational-databases/blob/filetables-sql-server?view=sql-server-ver15   FWIW, this doesn't work in many cloud scenarios, so...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed...

• This reply was modified 5 years, 6 months ago by pdanes.
• This reply was modified 5 years, 6 months ago by pdanes.

Two things.

1. Filetable (2012+) solves some of the code hassles of using FileStream. Filestream uses a File I/O access, but not a SMB share.
2. Rather than help a normal...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed in a...

Not really - I have  ONE problem: I don't know what I'm doing.

You stated that compiling the procedure normally - works fine. ...

Not really - I have  ONE problem: I don't know what I'm doing.

You stated that compiling the procedure normally - works fine.  But...