I suspect you need an index on one of the tables to improve the query performance.
You really need to work out which queries within the set of queries is...

Another way of writing the query:
;WITH DS AS
(
  SELECT DISTINCT
       DS.DateKey,
       DS.SafeRegionKey,
       DS.Attribute3ValueKey
  FROM rstore.OutputDataset...

Another way of doing it:
;with myTable AS
(
SELECT *
FROM (
VALUES (1,'B-6916','SEOK'),
(2,'B-6916','SEOK'),
(3,'B-6916','SEOK'),
(4,'B-6916','SEOK'),
(5,'B-6916','SEOK'),
(6,'B-6916','SEOK'),
(7,'B-6916','NEOK'),
(8,'B-6916','NEOK'),
(9,'B-6916','SEOK'),
(10,'B-6916','SEOK'),
(11,'B-6916','SEOK')
) V(ID,...

redgate have a tool for generating test data that looks quite good. I don't know how much it costs but it would save a lot of effort.
https://www.red-gate.com/hub/product-learning/sql-data-generator/how-to-generate-various-forms-of-realistic-data-for-testing-development-and-prototypes

Misha_SQL
You might need to add System.Data to the project...

VB Script is different from normal VB, you can't declare a variable to be a type. e.g. you can't do "Dim i as integer" you just have to do: "Dim...

It look like the script shouldn't run at all.

you have
you have Dim oExcel As New Microsoft.Office.Interop.Excel.Application = Nothing
then later down you have:

Working now on this link: http://www.sqlservercentral.com/articles/ADO.NET/168710/
But not the one at the top of this page (https://www.sqlservercentral.com/articles/C%23/168710/)

The article isn't available

7. on the cloud you are using someone else's machine

Have you tried updating the FK column values to NULL before deleting the rows?

One of our systems has about 500 stored procedure scripts that need to be run on a release. To do this I concatenate all the scripts together in one file....

All other things being equal it will take longer to update the table with more columns. If only because there is going to be more disk IO in reading the...