My opinion (like I stated above and like Ken implied) is that query hints are RARELY needed. There are use cases for them, and I do use "OPTIMIZE FOR" more...

My opinion - query hints are rarely best practice and often lead to other issues.

If I understand things right, you are taking out an exclusive lock on table 1 when...

If changing code is a no go, is adding code OK?

If so, you could set up a linked server from A to B and then set up a trigger on...

Quick google brought me this:

The master key is used to encrypt and decrypt sensitive data, such as credentials, that are stored in the database. If the master key is missing...

Linked server I think  is the only option, but personally, I'd refrain from doing something like this. My style is to keep my stored procedures contained to the system they...

SQL won't associate the view with the linked server. You will need to update the code to tell it to use the linked server. IF you break the single system...

My GUESS is since you have implicit transactions turned on, the delete is happening in batches and the "sync" is only happening AFTER the transaction completes. So if you are...

I'm not sure about your response. Did you configure the SPN's or not? If you didn't, I would configure the SPN's. If you have configured the SPN's, then my next...

Sounds like an SPN issue. Did you configure the SPN's?

As a guess - I would say you have no explicit transactions, right? If so, then the commit will happen as soon as the command completes. What I mean is...

My opinion - don't use activity monitor. It is a performance suck on the server and long term runs can cause issues in SSMS too. Plus, some of the metrics...

The risk with a VS deploy though is if you have multiple SSIS...

There might be some fair overhead to getting the current length of a text column.  If you really have to have that, add a column to...

There might be some fair overhead to getting the current length of a text column.  If you really have to have that, add a column to the...

I just wanted to point out that it also depends on how you deploy.

If you deploy using SSMS, the SSMS version MUST be the same as the SSIS version. I've...