Ok... so no test data provided in a readily consumable format.  The following code will help you do what you're trying to do.  It shouldn't take much a a leap...

Thank you so much. I am not cancelling it. Luckily the status showing 3%. I am saved. 🙂

But what could be the reason for that much slow ness?

2 weeks...

There is currently (though I'm working on it), no code that will make the "best" assignment because things like logical fragmentation are averages at a given time and provide no...

Me too.  Always have.

Remember TempDB when you do this.  If it has a different collation, you might be in for a heap of trouble...

Thanks for the info... I'm still waiting on data...

Ok... I think I'm ready for ya! 😀  Post some readily consumable data in the form of a CREATE TABLE statement...

Wasn't it you, David, that said (admittedly paraphrasing a bit) "If you're the first person people seek out for help on a problem rather than the last, you might be...

To be sure, I could never do the job that you do.  Thanks for what you do.

As far as the article you posted a link to, it's pretty good advice...

As a bit of a sidebar, you listed your week numbers as follows...

W51-2021

W52-2021

W3-2022

That's actually a really bad thing for you folks to be doing because they're NOT sortable.

The week numbers...

Ok... I think I'm ready for ya! 😀  Post some readily consumable data in the form of a CREATE TABLE statement and some data that's coded to be inserted into...

The week 53 problem is because...

Ok... I've got the week number part down to a nice, high speed single formula.  I need to add the year in but it' 03:17 here and I have to...

Quite contrary to popular belief, index REBUILDs are NOT a problem compared to REORGANIZEs.

Here's just one example.  I had a table that had an ever increasing Clustered Key that contained...

For those interested, here's the profiler run I fan just a bit ago.  It doesn't contain all the tests but it doesn't really matter because the extra tests just prove...

I would...