Best of luck on it. You should see a radical improvement in speed.

There is no way to decrypt it (I mean, maybe there's some deep level hack, but nothing functional within normal operations).

I agree with @Cebisa. Get a certificate you can share....

Instead of one giant transaction, break the delete up into smaller transactions. Simple or Full recovery, won't matter if the single transaction is bigger than you have storage space for.

Mainly you need to look for what's using memory in such a way that the pages will be flushed. Again, if everything else is fine, this is probably just normal...

Instead of a cursor to walk the code, what about simply using the SELECT statement with an INSERT statement to add the code to the table variable? Better still, why...

Piling on because this is a serious topic.

First, yes, using READ UNCOMMITTED is actually a much better choice than painting your code in NOLOCK hints.

Next, the fact is, reading uncommitted...

And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No real information...

Sure thing. And since you're just getting started in the wide world of query tuning, I'd suggest getting copies of my books (one is free in digital mode). Also a...

Without a lot more details, it's really hard to say what could be the cause. Sounds like the application server is doing something funky which results in excess CPU use....

Thanks for your feedback Grant, and for confirming my suspicion. I was noticing the many many duplicate suggestions and thought it seemed extremely generic in nature. It seems it...

Good catch.

Yep. Impossible. You simply can't combine database management systems in this way. They're not compatible. To solve a problem like this, you'd need to create some type of service to...

The Database Tuning Advisor is an actively dangerous tool to use. It makes a lot of recommendations. Most of the time, they're useless. You can see right there in the...

Hmmm... Sorry. I can't think of anything else it could be. A backup includes Query Store and there's no step you have to do or command or anything. It's just...

Everything that Jeff says, plus, under resourced servers, network configuration issues, and a whole slew of other system, network, OS, or server configuration issues. Just based on the information, "things...