Please disregard this post, there is all sorts of wrong with it. The local server is not an outward facing server, so it is impossible for the aws server...

Below are the errors when I try to run a select statement:

OLE DB provider "SQLNCLI11" for linked server "my_server" returned message "Login timeout expired".

OLE DB provider "SQLNCLI11" for linked server...

<removed previous content>

I'm so impressed with the code Paul, amazing work!

The developer here decided to go another route and create a SP that runs in 1 minute.

Thank you all for...

Thank you MM, I will try that first thing tomorrow morning. Very kind of you.

TheSQLGuru (11/12/2013)

---

Are you REALLY REALLY REALLY sure the code is the same on both servers?!?! :Whistling:

I was just looking for some simple action on the column, like a mod...

I wiiiish I could post the execution...

TheSQLGuru (11/12/2013)

---

I don't have (unpaid 😎 ) time to give it a go, but I would look to unwind that logic into the SELECT statement if possible.

Also, to...

Those are good workarounds, and it might be what we will end up doing. The SQL statement is something like this:

select someID, right ('0000000000' + convert(varchar(10), a.someID, 10)) +

...

Below is the UDF:

CREATE FUNCTION [dbo].[CheckDigit](@vol varchar(50))

returns int

as

begin

declare...

You are right, that's what they were.... 🙁

I was hoping they were something more important, and they would be the reason why my query runs faster in...

This is a shot in the dark, but I am putting it out there just in case.

I compared the actual execution plans and the XML of the staging execution plan...

I really appreciate your response and patience!

If I run Profiler, the sql statement will never finish. haha

I am using sp_whoisacitve. the CPU usage is much, muuuuch higher on...

Hi everyone and many thanks for your responses.

I had already checked on differences between table schemas, indexes, data, and also on wait/locks/etc. but didn't find any differences. I ran...

Hi Kevin, yes, I agree with you, UDFs are a nightmare for performance. I have replaced them before and have looked like a hero. haha. And when...