I've found that too many people apply too much consensus and not enough test code.  It's one of the main problems in a lot of IT shops.  There's also the...

Based on what you said about being able to recover from bad deletes and updates, my recommendation would be to setup the tables for System-Versioned Temporal Tables.  That means that...

On the above, you might want to check your baseline performance for a couple...

Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was taking 2 hours before and still taking same time after database reduced...

Yes Anthony,

It was just the MAXDOP  set to 2!! Now it's back to working properly.

Also analyzing the differences with the previous server, I noticed that the Full-Text Upgrade Option...

I don't know VBA but, looking up the command, I'm thinking that BCP.EXE using the "query out" option might do it for you (and it's nasty fast).  I don't know...

The question now is... do you know how and why it works?

https://www.google.com/search?dense_rank+sql+server

Use DENSE_RANK instead of RANK in pietlinden's code.

Understood as to what you've done.  Phil's question is what were the conditions before the shrinks?  For example, if your database had a...

OK, let me start by answering your questions/concerns:

• The Trigger methodology I am using is what wasa showed to me. I figured it would be good for a "first...

That's what I'm thinking, as well, but I just didn't want to assume.

Lordy... why are you using a homegrown temp table version of a cursor to do this?  It requires you to materialize the DELETED logical table, has two forms of RBAR...

I have a question based on the error... do you have Replication running or did you have SET IDENTITY _INSERT ON turned on for a table?  It's not easy to...

My apologies, Grant.  There's a bit of confusion on my part from your answer.  Your article seemed to indicate that PASS was in a bit (probably an understatement) of financial...

Does that mean that the virtual summit didn't take in as much as was needed, Grant?