It is...

First time I've hit. Just a little test, since I'm only running on a local machine with a container for a database, turning off Encrypt and you don't need the...

Latency?

I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.

I have a magic phrase I've memorized and you can have it too.

"I don't know, but here's how I'd find the answer..."

Now, you have to have a plan...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Thanks for the feedback all. No, no hate on Trace. I was dead serious in what I said about never questioning anyone using it ever again. Also, equally serious about...

And I understand it's fixed now.

Next time, please, a link. I tracked it down. Seems to be missing or something. I've sent it on to those who might know.

SQL Server 2022 Forum on SQLServerCentral

All set. I tested to make sure posts can go up, so you should be ready to go. Ask away!!

Good point. I'll see what I can do.

Make sure you turn on blocked process report in Extended Events. It'll be a lot easier to KNOW what's going on rather than relying on some random people on...

It's not traditional ghost rows. Those are from a simple delete and you'd never see what you're seeing (I stand by my very first post in this thread on that...

You didn't indicate schema in your pseudocode. Did you use schema name in your query? (Recommend you always do to avoid ambiguity) Any tables, views, or synonyms w/ the...