Think of it as a toggle. Instead of off to on, it's like to unlike. So you hit like, it marks it as a like, but changes it to unlike...

They are pretty desperate to make this not about them. It isn't... but it also is.

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.