I like your take here Steve. I would to add an addendum thought, which is "don't have to". Over the years the skills required for career growth, or even...

Thank you for articulating this perspective! It's how I instinctively live my life but wouldn't have been able to express it so clearly. I really like your "can't yet"...

If this is in SSMS, I often double click the error and it jumps to the line, which usually gets me close enough to figure out what is wrong.

The other...

Be careful changing collations and make sure you understand if this was done for a reason.

A reboot often fixes things like this. As Johan noted, reboot the OS, not just restart the SQL service.

Any updates added differently, Windows updates or patches?

I always find those "button" surveys in a toilet to be strange. Especially after the pandemic.

One would be wise to consider that a HR survey may be a backdoor to find people who are not content in their job, instead of a genuine opportunity...

• This reply was modified 3 days, 10 hours ago by Steve Jones - SSC Editor.

I admit that customer satisfaction surveys sent out by myriad organisations after the merest contact with them have become one of my pet hates. I only fill them in...

The program works, but all the queries I've "saved" to a workspace are gone. That was the part I needed, and I wanted a "local" file. I don't mind syncing...

You might have a different collation in tempdb. That's often a source of problems.

You can add the COLLATE clause to your query to force a certain collation.

https://learn.microsoft.com/en-us/sql/t-sql/statements/collations?view=sql-server-ver17

Ugh, this is not the season  I wanted. Lamb being out is killing me.

I'll drop this here. Low cost: https://vertabelo.com/

Redgate just acquired this.

Disclosure: I work for Redgate.

To me, this is why you need a curated data set and a separate sandbox for dev work. Unless this is data fixing customer service work, the client should provide...

Lol, I think it depends if you're the person attempting to purchase a beverage or vote or the person approving them. The license holder would prefer Feb 28. The legally...

Have to check the logic, but likely there is some filter (WHERE) looking for certain rows that is missing things. I've had similar issues when someone assumes a process is...