Sorry, had to step away for a presentation. I agree with the suggestions so far.

Close off the connections or restrict access to the database would be the best guess I have. Probably you just need to plan on tearing down & rebuilding the AG...

Can you show the code where the function is used? That will allow people to understand the context in which they have to work. Otherwise, the answer is, pull the...

Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude...

BUT!!!

Know...

Execution plans, run times, I/O, data, data, data. You can't simply say IN good, NOT IN bad without data. You also can't say NOT IN good, IN bad without data....

I'm with Jeff. Pick and choose which of these indexes you drop & recreate. There are many, many tests out there that show inserting into a clustered table can be...

I'd suggest next time you run a blocking report to understand why it's blocking. SELECT COUNT(*) has to do a scan, either of the table or an index. It's counting...

Running out of support software is a serious business risk. I'd focus on that above anything else. I know this stuff comes with a price tag, but talk to the...

Take a look at the execution plans when it's compiling in each compatibility mode to understand how the behavior is changing.

You're trying to do an in-place upgrade? This is the installation software that is generating these errors? I'm unclear precisely what's happening.

Also, whatever you do, avoid updating to 2014. It's...

Without seeing the code, it's hard to know for sure if this is the best way to get things done. It is possible within T-SQL to reference a data set...

Distributed Replay

Well, that's the answer to your questions.

Without data, we're talking nothing but guesses, and vague bad guesses at that. Go and turn on monitoring on the server. Set up Query Store. Enable an Extended Events session....