Skip to main content

Questions tagged [sql-server-pdw]

Microsoft SQL Server Parallel Data Warehouse is a version specifically built for high performance large data warehouses.

Filter by
Sorted by
Tagged with
1 vote
1 answer
58 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 (...
Suseong Park's user avatar
8 votes
1 answer
679 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 ...
crokusek's user avatar
  • 2,120
1 vote
0 answers
289 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 ...
Neil P's user avatar
  • 1,274
6 votes
1 answer
729 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.
Zinx's user avatar
  • 309
2 votes
1 answer
511 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?
Akash's user avatar
  • 1,032
0 votes
1 answer
236 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.
Sam's user avatar
  • 1
1 vote
1 answer
610 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 ...
Icarus's user avatar
  • 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 ...
Icarus's user avatar
  • 337