If you really want performance, create a wrapper proc that determines if you're doing an INSERT/UPDATE/DELETE and then a proc for each. MERGE generally stinks on performance. Period.

Happens to everyone. No worries.

Yeah, I was thinking something similar. I wonder if it's the unicode string that's causing the issue.

Database projects are more than a little difficult to work with in source control, and I do source control my databases. So, external tools are generally better. For free, when...

Bad news is, probably not. I mean, do run validations on all your hardware, because that could be the issue. However, data corruption can be from external sources. Power surges...

Thanks Grant

I accept your point - why is the system giving me a "select permission denied" when using the scalar variable in a select statement, when the user is...

The key difference is a result set. Scalar functions return a value, not a result set. So they're not being "selected" from, they're being executed.

That sure doesn't sound normal. And this is related to the initial question?

Then you have to get a license to run Standard.

Developer edition is the best "free" one you're going to get.

Sounds like you're trying to enabled Query Store on the secondaries. That's only available in SQL Server 2022, not 2019. Here you go.

A) Testing is your buddy. Don't take anyone's word for it. Test it.

B) Probably not. In fact, that's almost the opposite of what I'd want to do. Presumably, guessing here,...

If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering...

Yep. Could be a real problem. No denying it. But, I tend towards this.

If I answer the questions, what does the job pay and when do I start?

Cause you wouldn't take my answers to those questions and submit them as your own to...