Steve, Ryan and I were traveling on Friday. It was a mess, but Steve and I made it home....

Unless you have some kind of direct evidence that anything is causing a problem, leave it alone. Don't kill sessions without knowledge of there being an issue.

There isn't a single correct answer to this. Here's my list of "I'm gonna need this" software:

SQL Server Management Studio

Azure Data Studio

VS Code

Git

Docker

Redgate Toolbelt (yes, I work for them, but...

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,...