Just thought I'd mention that I tried both cte tally schemes and they produce a different number of rows.     Jacob, yours seems to produce a doubled result set.

I agree that getting some timings across steps would help you isolate the problem.

IMO, you do NOT want to try to join to a view on a linked...

Good luck with that.    Be advised that our company has quit using linked servers because of security issues.    

Also, using SSIS or multiple "pulls" of data are permitted...

If you are trying to update data on Server B with a procedures or script running on Server A, then you are attempting what is called a "distributed transaction".   Requirements for distributed...

SQL Server Integration Services (SSIS) is another option.

Agreed.   If instead of updating, you want to delete all rows then re-insert them,  you can't make MERGE do it.    You have to code a DELETE statement followed by an INSERT...

I know that this topic has been over for a while but.... 

Be aware that at distances of 100 feet (or even 20 miles) there is little need to...

Can you try IN, instead of OR... that can sometimes produce two index seeks against one table instead of a scan.

Why? It does the job well.

Try this.

delete a

from #temp a

inner join employee e on a.id = e.id

-- Put the selection criteria...

My error. I usually put the WHEN MATCHED logic first. Thanks, Drew. 🙂

I would never have forgiven myself if I missed this one.

I'm just glad the date wasn't Thanksgiving.

So far you've only coded for an UPDATE on a match....

There are a lot of users (and developers) who, while competent in their own fields, are going through a learning curve for SQL. There is no...

If I may step for a moment, I would like to reiterate that the point of the calendar table is to simplify queries for all users, not just...

Hey Jeff, could you send me private message with your email? Your box is always overflowing.

Also, I need to know where to send...