What are the challenges you face when working across database platforms? Take the survey
Options

Fails to rebuild a partitioned table when online=on

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!
Sign In or Register to comment.