I’m sorry I don’t have a real example but I know when I see trouble at a distance

Please don’t get me wrong, it’s not that I don’t like...

Im hope I have understood the question right,

I think all you need is a function that would accept a string list and out put the data in...

Ok; if you have no options I’d say stage the data in your data source before inserting it directly from the vendors data source. This will help not to...

Openquery and link server is not the way forward; I wouldn’t advice for you to proceed with the current approach in transforming data. I would recommend you to do a...

This is just a idea; are all the services running on the same service account ? If yes, create a new windows account and assign it as the...

Using XML as a input parameter

-I wouldn’t use a XML as a input parameter to update a table; mainly to avoid the XML reader operation.

-This approach will lock...

If im not mistaken this is called the tripping point.

This is typical of how query optimizer handles such data. For some data the procedure works better and for others...

I’m not very clear on the question but I believe u need to create the impersonated user in the new databases

Just a quick question, You mentioned that you intend...

Did you rebuild your indexes after the migration ?

My first take on the query

I strongly suggest that you

- Break the query into smaller logical groupings to arrive...