Understood but that's not my question.  To be more clear, you stated that...

I'd rather write components in a project written in C# that yield the results that...

regarding reorganize - there is an exception to this  - if you have columnstore indexes that are frequently subject to deletions or that are subject on inserts in small...

That's the gist of it.  If you have indexes where logical fragmentation actually does matter for large range scans, you might want to include those but, again, that's going to...

As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?

To spread the I/O out, the typical reason for...

Ah... that's the ticket.  Thanks for taking the time to explain.  I was really concerned about...

Adelia,

Don't go yet.  I asked you some questions about datatypes that you've not answered yet.  If you let me know that the datatypes of the...

@databases nvarchar(max)='USER_DATABASES'

@FragmentationLow nvarchar(max) = NULL, /* don't defrag low fragmented */

@FragmentationMedium nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', /* left out index_reorganize because of https://www.sqlservercentral.com/forums/topic/rebuilding-and-reorganizing-indexes/page/2/?bbp-ajax=true */

@FragmentationHigh nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 int = 30, /* threshold medium...

Ah... sorry.  Looking back at the original post, I see that REORGANIZE was left out.  That's ok... it's still worth mentioning for other people that may read this thread.

Yes.  Do not use REORGANIZE.  It doesn't work the way you think it does.  It's so bad on indexes that fragment that it's actually the cause of the myth of...

I don't know about those stored procedures and can't help there.

Of a much larger concern, suppose you want to restore just one database?  Go check the documentation on that.  IIRC...

You're presuming an awful lot.  Why would you want "at least 2 files per filegroup" for a single table?

Also, I can see some instances where you might have specific reason...

Understood but that's not my question.  To be more clear, you stated that...

I'd rather write components in a project written in C# that yield the results that would be...

Now that you have your answer, would you please tell us what your stored procedure is doing?  I'm really interested in why bad...

Try it and find out that the...