Background of the issue: After the successful restoration of production data into the sandbox environment (tier 2) tried to reset DataMart mart through PowerShell, but it failed with below error. Error detail: ” Table ‘Datamart.DimensionValue’ uses a clustered columnstore index. Columnstore indexes are not supported in this service tier of …
Read More »