1,502 votesunplanned · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
Not planned at this time. Will keep this item open for future review.
Thank you for your feedback folks. We are actively looking into this scenario specifically with VS SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.
This feature is in private preview and will be available to all users in coming months.
This is being considered for a future release.
Thank you for the feedback folks. For now, you can use Alter Index reorganize as the online operation when rebuilding your CCI . We will reach out when this is on our roadmap. Please describe your scenario for this capability below and continue to vote. Thanks for your patience.
An error occurred while saving the commentMarty Piecyk commented
By the way, even queries with NO LOCK get stuck until the rebuild is complete:
SELECT TOP 1 * FROM VulnerabilityScope WITH (NOLOCK)
And, as expected, this results in an error:
ALTER INDEX ALL ON VulnerabilityScope REBUILD WITH (NOLOCK)