I guess my only exception to what Rick stated above is that business logic is frequently better done on the database side of the house.  FKs, Defaults, Checks, and a...

Same problem, but someone with a completely different perspective came up with very different solution. Maybe part of it was I was a database guy, and only had to...

They are not even Excel jockeys. One of them has a LAW degree. she just passed her bar exam and is not going into law.  The rest...

Cache is also temporary... very temporary.  Dropping procs based on what is in cache is a sure fire way to need to resurrect your resume and sharpen it up.  Seriously......

This is not a trivial task and great care must be taken in any such consideration because some of it is incredibly difficult to reverse if it just doesn't happen...

Very close to what Michael John posted, the most import tool of them all is... you brain.  It totally doesn't matter what tools y0u use, whether or not you succeed...

The following is going to be an major problem for 100 million rows...

SET IDENTITY_INSERT new.RLDX_ARCHIVE ON
INSERT INTO new.RLDX_ARCHIVE

There's a known issue with SET IDENTITY_INSERT ON... it forces...

They are not even Excel jockeys. One of them has a LAW degree. she just passed her bar exam and is not going into law.  The rest have psychology...

sorry image did not come across as planned, I missed an obvious on the key lookup that actual rows millions of rows more than estimated.  The even uglier part...

I seem to be in the minority here as when I was a jobbing developer I insisted that all of the necessary SQL code was encapsulated in Stored Procs. ...

Shifiting gears a bit, I almost blew a chicken bone out of my nose on the final sentence of the following post.  WallyWizard for President! 😀

https://www.sqlservercentral.com/forums/topic/what-type-of-join-is-this#post-3731678

The trace flag can be set at the session level (add 1 line of code at the beginning of the proc).  I wouldn't set this at the server level because...

How'd you figure that out and what was the "audit trail function"...

Hmmmm.... hadn't thought of that.  I normally wear one to...

That's some bad code there Mike.  I've seen some similar, but add a couple UNION statements and all with in an SSRS report.  Talk about slow...