Allow Set-DbaDbCompression to specify the WITH options when altering an index #6671
Description
Summary of new feature
Be able to provide with option such as ONLINE=ON (or even do this one automatically based on the version of SQL Server) and SORT_IN_TEMP=ON. These appear to generate as OFF.
Proposed technical details (if applicable)
ALTER INDEX [IX_TABLE_COLUMN] ON [dbo].[TABLE] REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = ON, ONLINE = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85, DATA_COMPRESSION = PAGE)
Latest version of dbatools as of writing
1.0.114