If a user knows the right login and the right location to use, they can connect with any tool at all.

There's no easy way to deal with what you're asking...

Any time a third party backup tool is introduced to the system, don't rely on anything anyone tells you on the internet. Test a restore. Did it work? Yes? Great....

If you're looking to expand your analytics skills, I'm going to pile on and say R or Python. Great choice.

Otherwise, man, this whole data management, data analysis, etc., business is...

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