Since MERGE statement is not supported, we are using CTAS for preparing the new table and using the rename operation.
Currently we do not have the TRANSACTION support for the RENAME operations.
When we have two rename operations we may run into inconsistent state if second statement fails.
RENAME OBJECT FinalTable TO FinalTable_Old;
RENAME OBJECT FinalTable_Stage TO FinalTable;
To overcome this, we need some workaround or support for transactions.27 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 10697293
Allow customers to define a window of time during the day where any internal maintenance should be performed in order to reduce impact to users during core business hours.
We have seen that internal upgrade/migration processes in Azure Data Warehouse can sometimes have impact on running queries (ex. performance and connection issues). If we could specify a time where impact is less likely, then it would improve the overall experience and availability.18 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 10342565
Often, after scaling, my database refuse to return results from large tables. This is after scaling from DWU100 to DWU 1000 (i.e. going UP in size). The fix I have found is to pause the database, wait 15-30 minutes, then resume the database. I assume this results in the database being reassigned to a new DW cluster.
Overall, I have found scaling to be a tenuous affair -- sometimes it works, sometimes it fails or leaves my database in a state where it basically no longer responds.
Hopefully this is a preview "feature" that will be fixed....9 votes
The open source tsqlt framework requires CLR which is not available in Azure SQL DW. A framework to to write unit tests would increase trust in the queries.6 votes
Once a proc is executed and if we try to stop it, its not working. Sometimes it takes 6-8 hours to get it cancelled
Once a proc is executed and if we try to stop it, its not working. Sometimes it takes 6-8 hours to get it cancelled6 votes
- Don't see your idea?