Thanks for the code modifications, Steve.  I'll take a deeper dive than just looking at it.  Nice to see someone actually test both out a bit.

In the past, I've shyed...

Thanks a lot Jeff for...

As a bit of a sidebar, man!... The supposed SQL Format for the code windows is absolutely horrible! 🙁  I wish they'd do something about it.

Here's Rev 02 with a shedload more documentation in the flower box and 3 extra columns that seem useful to me.  I think I may turn this into an article...

• This reply was modified 2 years, 3 months ago by  Jeff Moden. Reason: Added warning to header

Thanks Jeff,,

I have been using the formula:

if ($Average_Fragmentation -gt 40.00) { Write-Host -ForegroundColor Red "$Index_Name is more than 40% fragmented and will be rebuilt."; $index.Rebuild(); Write-Host -ForegroundColor Green...

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...