Questions tagged [azure-sql-data-warehouse]

For questions about Microsoft Azure SQL Data Warehouse, the cloud-based, massively parallel processing database for relational and non-relational data.

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
0answers
177 views

What cases benefit from the Reduce, Replicate, and Redistribute join hints?

The From Clause Documentation starting with SQL Server 2008 briefly mention 3 join hints and their basic mechanisms: Reduce Replicate Redistribute However there does not seem to be much information ...
3
votes
1answer
385 views

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL ...
2
votes
0answers
80 views

Why does outer apply cause a broadcast move?

I've got an outer apply with a condition on the distribution keys. select e.a ,e.b ,p1.c from e outer apply ( select top 1 p.DateStamp from p where e....
1
vote
1answer
282 views

How to see what's using TempDb space in Azure SQL DW?

I'm having problems with TempDb being full. Are there any system views I can see to diagnose what's using up TempDb and/or how much space is still available on it? It would be awesome to also see ...
1
vote
1answer
31 views

How to index cube style queries with changing aggrigations

I've got a query that emulates the CUBE function. This is many different aggregations unioned together. select x,y,z, sum(a) from tbl group by x,y,z union all select x,'all',z, sum(a) from tbl group ...
1
vote
0answers
101 views

Output result of DBCC PDW_SHOWEXECUTIONPLAN into a variable

I would like to output the results of DBCC PDW_SHOWEXECUTIONPLAN into a variable (or table, I'm not fussy!). I know the PDW syntax is quite different when it comes to outputing results, which means ...
1
vote
1answer
435 views

Lock a table for a CTAS upsert in Azure SQL DataWarehouse

I have a type 2 dimension in Azure SQL Data Warehouse. Essentially I am creating an interim table with CREATE TABLE myDimension_temp AS SELECT ... FROM myStagingTable; etc After the CTAS is ...
0
votes
0answers
34 views

Are clustered indexes in Azure data warehouse ever a good idea on large tables?

Azure data warehouse supports both clustered and non-clustered indexes in addition to columnstore (which is the default for any new table). I know that having a large clustering key is normally ...
-1
votes
1answer
405 views

How to copy data from Azure SQL DB into Azure SQL DW

I need to copy some data from an azure SQl DB instance into my azure data warehouse. The most obvious way to do this is to use Elastic Query, similar to the below: CREATE EXTERNAL DATA SOURCE SqlDb ...