Questions tagged [sql-data-warehouse]
108 questions
-1
votes
1 answer
Slow running query in Azure SQL Data Warehouse
I have a very simple query which I am running in Azure SQL Data Warehouse but it is taking around 40sec to execute.
Table definition:
CREATE TABLE dbo.orders
(
location_code VARCHAR(8) NOT NULL,
order_date DATETIME NOT…
Deepanshu
- 69
- 1
- 1
- 4
-2
votes
1 answer
Database backup on Azure SQL Data Warehouse
is there any way to backup the database say 'ABC' and then restoring with the name 'ABC_Old' on Azure SQL Data Warehouse?
Any help is appreciated. Thanks!
Iam_NC
- 45
- 6
-4
votes
1 answer
Map data with CTAS in SQL Server from source with different column names to existing SQL table
Scenario:
Is source table SourceData (Name, Number, Date)
Is existing table ProdData (ProdName, ProdNumber, CreatedDate)
Requirement:
Dont import from source if already exists in prod data!!!
Import rows from source to prod data, keep existing rows,…
user3462947
- 89
- 10