As yet another side bar, unless you have a REALLY good reason to move to 2022, I'm here to tell you that, compared to 2017, 2022 is about 30% slower...

Duplicate post deleted.

As a bit of a sidebar, I'd change the YrMo and YrMo2 columns to a DATE datatype.  It's 1 byte less than an INT and a whole lot more useful...

You bet, Rod.  Thank you for the feedback.

As a bit of a sidebar, I have a now fairly old laptop that I got a couple of year...

BTW... thank you for the heads up on the UK postal thing and the really incorrect premise that the computer is right until you can prove it's not.  Both are...

Sorry Jeff  for the  inconvenience. kindly see the below code

INSERT INTO [dbo].[10_SOR_MB]
           ([item_id]
   ...

Search in Duck-Duck-Go for "installation requirements for SQL Server Developer Edition" leads us to a link for the following...

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019

That has links on it for other versions.

Then, this is fairly easy even in a 24/7 environment (although you didn't list the CREATE TABLEs in full so not 100% sure)

To be sure, the first thing that I'd...

The article cited "This also coincided with a (an unrelated) law that changed saying computer systems were presumed correct and anyone accused of a crime had to prove the computer...

I'd much rather they spent their time making SQL Server 2022 run as fast as it used to in 2017.  They "broke" it in 2019 and still haven't fixed it...

Do any of the tables that you want to delete from have IDENTITY columns in them? I don't see IDENTITY anywhere in your  CREATE TABLE scripts but just need to...

Elon Musk moved "X" back to on-prem with, reportedly, a substantial savings.

There are a ton of other companies that have or are considering moving back to on-prem.  Here's a decent...

Just an opinion here...

While I agree with the statement quoted above (because "It Depends" is always a consideration), I've found that a...

Heh... speaking of AI...

Could you use the AI to suggest to you good folks how to fix all the problems with the forum software and the article submission software?

Those two...

Yeah... sorry... admittedly, I only took...