Fails to rebuild a partitioned table when online=on
DaBow
Posts: 1 New member
When I select a partitioned table for a rebuild, invalid SQL is generated, causing it to fail.
Current bad example:
ALTER INDEX [NCI-MessageTag] ON [email].[Queue] REBUILD PARTITION = 2 WITH ();
If I update the query to this, it works:
ALTER INDEX [NCI-MessageTag] ON [email].[Queue] REBUILD PARTITION = 2 WITH (ONLINE = ON);
PS, It would be nice if it could add RESUMABLE = ON to large rebuilds!
Current bad example:
ALTER INDEX [NCI-MessageTag] ON [email].[Queue] REBUILD PARTITION = 2 WITH ();
If I update the query to this, it works:
ALTER INDEX [NCI-MessageTag] ON [email].[Queue] REBUILD PARTITION = 2 WITH (ONLINE = ON);
PS, It would be nice if it could add RESUMABLE = ON to large rebuilds!
