In SQL Server 2017, I want to move ALL Heaps in a DB to a secondary filegroup. What's the easiest way to do this?
This question is only for Nonclustered Indexes.
In the process of optimizing an older legacy database.
- I want to write a script to move all heap tables with a cursor loop similar to the Stack Overflow link above.