Distribution change RRS feed

  • Question

  • Hi Everyone

    I have made updates to a number of tables on our instance over the last few days. The instance is paused each night after working hours and then turned on for ELT loads and analysis during the day. I have changed the distribution and indexes on 2 tables and when I check in the morning I see they have reverted to a hash distribution and clustered index rather than replicate and columnstore. No one else is making admin type changes on the instance. Any ideas?


    Wednesday, July 24, 2019 1:31 PM

All replies

  • Hi Seanie,

    Do you have an Azure Support Plan (link)? If you do, can you please open a Support Request with Azure Support. If you do not, can you please send me your Azure Subscription ID to AzCommunity and I can send you next steps to have a Support Request created. 

    This needs to go to support to be addressed, as it appears to be a bug.



    Thursday, July 25, 2019 3:32 PM
  • Want to follow up on this issue to see if you still require assistance with this issue. Please continue the dialog if you are still seeking a solution.



    Tuesday, July 30, 2019 12:36 AM