You had better started a new forum post ! Whenever I see new answers to old Questions, I skip it

the point is to end the previous statement with a semi colon

and showing examples of CTE's...

you could implement a database ddl trigger handling on object creation for tables starting with those prefixes

( handle registration of create table + timestamp and drop table (+ timestamp...

I think RedGate has got some nice tools to handle that kind of operation

.....

Create another filegroup, and duplicate the table on the new file/filegroup.  Use the SWITCH command to move the data from the old to the new table.

ALTER TABLE schema.OldTable SWITCH TO...

too many ? There should only be a single one !

ref: https://blog.sqlauthority.com/2020/04/11/sql-server-multiple-log-files-to-your-databases-not-needed/

( I only temporarily used a second ldf file to be able to extend to a new disk and...

Also keep in mind by default it will only report progress every 10 % !

Use Jeffrey's script to have the prognosis.

Here is a nice reference by Brent Ozar regarding RCSI: "Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide"

Have a look at the "Gotchas With Implementing...

How correct do you need your results to be ?

Check this great blog post by Paul White:  "The Read Uncommitted Isolation Level"

Asking around how colleagues handle it or web search for a minute, especially nowadays, chances are someone already 90% published of what you need.

Although I must admit: "what you automate,...

Ask for "view definition" to be granted to you, so you can seed an objects composition.

GRANT view definition TO [user_or_role]

also keep in mind, the SQLServer service account needs to be granted usage of the given paths !

Did someone add the registry key settings to disable the old TLS and/or SSL protocols ? ( and not reboot the node at that time )

That is not advisable as this will always start the job, even when it is disabled !

My point is:  When a sysadmin or "sqlagent job manager" disables a job for...

check out msdb table dbo.sysjobhistory

it logs execution times per step.