Guessing.

It's SSMS. Someone is using the GUI to edit tables. They're getting warnings and ignoring them.

Please don't cross post the same question across multiple forums. It makes it hard to keep a focused conversation and answer the question efficiently. Please, any additional posts on this...

Be careful of autogrowth here. Also, it's a good idea on any drive with auto-growth enabled, create an file called 'deletemeinemergencies' or similar. Make it big enough, say 20 or...

To keep conversations focused, please don't cross-post between forums. Anyone who wishes to discuss this, there's a conversation going over here.

To keep conversations focused, please don't cross-post between forums. Anyone who wishes to discuss this, there's a conversation going over here.

Grant ,

I can see now where Cursor is not needed rather  use a simple select statement with insert records into the table variable.

Grant, thank you. I will rewrite ...

Good luck on it.

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