Actually, it could be simplified even more.  Since it always tries to run on Thursdays, we don't need to figure that out.  We just need to figure out if the...

Totally agreed.

12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.

In terms of your last question, changing logins makes changes in master. Changing...

As a bit o a sidebar, I've found that the cutover point between DELETES and COPY to a new table is actually about (depending on the table, of course) only...

Hadn't thought about that.  Thanks, Scott.

Looks like they fixed it!

Heh... pretty typical for things like this.  The OP asks a question and then never participates in their own thread.  While some great code has been posted, there...

these are read-only dbs.  there's...

Heh... pretty typical for things like this.  The OP asks a question and then never participates in their own thread.  While some great code has been posted, there are still...

Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID...

The worst schema I had to implement: A customer wanted us to reboot the server for patches on the first friday of the month around 1am.

How do you schedule...

Mostly but, personally, I wouldn't...

Thank you Jeff,

I have been emailing them everyday since last week. Did not get any response, therefore started a thread here.

Any other email or person I can reach out...

Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID base on...

If the clustered index has an ever increasing key and the inserts are following that key, you won't get page splits.  If, however, the inserts are followed by "ExpAnsive" Updates,...