Questions tagged [sql-server-pdw]
Microsoft SQL Server Parallel Data Warehouse is a version specifically built for high performance large data warehouses.
8 questions
1
vote
1
answer
64
views
Select into query, insert fails, but the table is created
I am using SQL Server 2016 and I tried to the following query.
SELECT CONVERT(BIGINT, 'A') col1 INTO #tmp
This query is obviously in error. Because it does not convert. However, the temporary table (...
- 11
8
votes
1
answer
709
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 ...
- 2,130
1
vote
0
answers
305
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,284
6
votes
1
answer
735
views
Server roles in SQL Server 2016
There are 3 new server roles in SQL Server 2016:
mediumrc
largerc
xlargerc
Any idea what these are for? Google doesn't give any information about these.
- 319
2
votes
1
answer
512
views
Is it possible to deploy Microsoft PDW on Azure?
I've read about it and want to play around with it for a bit.
I think it requires a minimum of 4-5 machines to run, which is feasible with Azure IaaS, but how do I actually deploy it there?
- 1,032
0
votes
1
answer
237
views
SQL Server 2012 Vs PDW [closed]
We are migrating to SQL server 2012 to PDW.
Any SQL script for Comparing the data between SQL server 2012 and Parallel dataware house or any tools to compare.
- 1
1
vote
1
answer
624
views
Raise error from Stored PROC in SQL Server PDW
I need to do some validation inside a stored procedure before I continue processing but SQL Server PDW (SQL Server 2008 R2) does not support RAISEERROR inside stored procedures.
Is there any other ...
- 337
8
votes
3
answers
2k
views
Updating a big replicated Dimension (SQL Server PDW)
We use a SQL Server PDW appliance for our data warehouse. One of the tables in our warehouse is a replicated table with about 20 million rows. As part of our ETL process we need to expire old records ...
- 337