I am already able to move nonclustered, nonunique indexes with page count of 10,000 or less to secondary filegroup manually one by one. I have to move 1,100 of them.
I am looking for a way to do this programmatically either in groups or all in one shot. I'm using SQL Server 2017.
Thanks in advance