If this is a service account, why is it getting locked?

If users are fat-fingering the passwords, then I suspect that these accounts are being used improperly.  Are you sharing the...

Here are a couple things.

Assuming you are going...

For what reason are you installing replication on top of an Availability Group?

If you can provide us with the goals of what you are trying to accomplish, we can probably...

SELECT *

FROM TableA as A

INNER JOIN TableB as B ON A.SKU = B.SKU

WHERE A.Price <> B.Price

Actually, it may not.

If start date is at midnight, such as '2019-04-14 00:00', it would not count...

Statistics are not updated when  you re-start an instance.

And, re-starting...

• This reply was modified 6 years, 5 months ago by Michael L John.

That may not be enough.  You should try to update statistics manually and then see what how that affects your query. The symptoms you describe are a classic example of...

Problem is that the person doing this doesn't care and doesn't test.  He thinks he knows it all and doesn't listen to my recommendations when I can demonstrate that...

This is the default setting in SQL Server.  When you concat a null, it will return null.

The behavior can be changed, however this setting is deprecated.  Like @Taps suggested, the...

I doubt if you need a loop or a union all.

Use Jeff's splitter, and either join to the function or use EXISTS.

You are only providing us part of the information, and your requirements have changed somewhat since your original post.

Again, I am making a guess here because I cannot see what...

If it ran for 15-20 seconds before, did it produce the correct results?

The original code you posted will not run. The syntax is not correct. Can you post the code...

Your date calculation may not produce the correct results.

Is the case of this code correct? Does it match the database? I'm guessing that your database is case-insensitive, but it's infinitely...

There are more things wrong with this query than just this part.

For starters, this join syntax, while it works, is not really preferred.

Do you know the syntax for...

Correct, that will not work. It appears that you need an EXISTS clause in the where clause. Without seeing the query and tables, the syntax is as follows:

SELECT

...