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

Thanks for the followup and glad you fixed it.

As DesNorton notes, if you want a full period then normalize to midnight, as opposed to someone using sysdatetime or DateTime.Now() as a parameter. I would document and decide if...

Thanks for the followup. I was thinking datatypes as I read the first post today, as this can sometimes be an issue.

The other thing I had in a baseball database...

Are these both Windows auth credentials? I don't think you can easily do this as there is a single account running the overall package.

Can you use SQL Auth for one?

Yeah, need to specify a version here. I used SQL 2022 and that shows this reacts differently.

100 was the value for a few years, but I think that is different...

• This reply was modified 15 hours, 26 minutes ago by Steve Jones - SSC Editor.

PRs are a good way to try and catch issues early. Running all deployed code through a PR doesn't necessarily prevent what you've listed, but it does give someone a...

Wow. The silence indicates whoever reads these post has not given much thought to finances and retirement. The sooner you think about it and make financial plans the better...

Watching costs is a challenge. Even for companies where they have a person(s) doing this.

The spot VM is a good idea. It's also good to learn how to script this...

Two tests I think about. Was told this by an interviewer while in Uni.

1. Would I have a beer with you after work?

2. Would I be willing to drive on...