Stack Overflow
Stack Overflow

Questions tagged [parallel-data-warehouse]

A massively parallel database environment built on top of SQL Server and run from custom hardware. Parallel Data Warehouses use a modified version of T-SQL to support enhanced parallelization.

A massively parallel database environment built on top of SQL Server and run from custom hardware. Parallel Data Warehouses use a modified version of T-SQL to support enhanced parallelization.

Also known as Analytics Platform System. https://www.microsoft.com/en-us/sql-server/analytics-platform-system

51 questions
0
votes
1 answer

How to concatenate many rows with same ID in SQL PDW/Azure SQL DW

My table contains the details like with two fields. I want to get the the unique details with DisplayName like: I want to know how to do this is Parallel Data Warehouse/APS since the FOR XML PATH function is not supported in PDW. 1 Editor,Reviewer 7…
Kamran
  • 147
  • 4
  • 14
0
votes
1 answer

(Azure) Data Factory to Data warehouse - Dynamically name the landing tables and schemas

I plan to move data from a number of databases periodically using Azure Data Factory (ADF) and i want to move the data into Azure Parallel Data-Warehouse (APDW). However the 'destination' step in the ADF wizard offers me 2 functions; 1- in the case…
Jimbo
  • 3
  • 5
0
votes
2 answers

loading data into temp table on PDW

use tempdb; CREATE TABLE #tmpMain( [PNRRecordLocator] char(6) COLLATE Latin1_General_100_CI_AS_KS_WS NULL, [PNRCreateDate] date NULL) WITH (LOCATION = USER_DB) insert into #tmpMain from {TKT].[TktCpn] where [CpnDepLocalDateTime] >…
Kamran
  • 147
  • 4
  • 14
0
votes
1 answer

Comma Separated List from SQL Grouping

I'm trying to build comma separated list per group in sql, As am using Parallel Data Warehouse i need to do this without using FOR XML or recursive function ( not supported ). any other way to achieve this ? Input: ID Value 1 2 1 3 1 4 2 …
shashikiran
  • 369
  • 1
  • 5
  • 17
0
votes
1 answer

How to delete data in DMVs( system tables) in Microsoft Parallel Datawarehouse

I need to delete some of the data in a system table. Is there anything that I can do?
PyCodoop
  • 40
  • 1
  • 7
0
votes
1 answer

SQL PDW set multiple variables in SELECT

I am working in SQL Parallel Data Warehouse / APS. I am trying to set the values of multiple variables in a single SELECT statement. My code is: DECLARE @var1 int ,@var2 int ; SELECT @var1 = col1 ,@var2 = col2 FROM A ; PDW is…
skyline01
  • 1,919
  • 8
  • 34
  • 55
0
votes
2 answers

Is there any performance impact on having NULLs on Foreign key column in a Data mart

We are currently working on Data mart design. We are having many Foreign keys to dimension tables. We are thinking whether to allow NULL in Foreign key dimension fields or have -1 to represent NULL values. Kimball suggests to keep default row for…
Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
0
votes
1 answer

Can tsqlt be used with parallel data warehouse?

Saw that CLR functions needed to be enabled to use tsqlt. Can I actually use it in PDW ? Or any other ways or tools to perform unit testing on PDW ? Thanks,
JJ0022
  • 33
  • 6
0
votes
1 answer

How to write update statement with multiple table Join in Parallel Data Warehouse?

I am having difficulty trying to write an update statement On TableA with Joining of TableA,TableB,TableC in Parallel Data Warehouse, but it is throwing an exception. E.g : Simple Example Update TableA Set EnableFlag='Y' From TableA INNER JOIN…
Abhi
  • 13
  • 2
0
votes
1 answer

How to Extract DDLs from Microsoft Parallel Data Warehouse?

Please suggest How to Generate the scripts from Microsoft Parallel Data Warehouse... I have already tried using SSMS 2016 by using my PDW credentials... But i failed to Generate the scripts... Regards, Abhishek
Abhi
  • 13
  • 2
0
votes
0 answers

Which is faster in Parallel data warehouse : Delete or Update?

In Interview I have been asked that can you tell me which is faster in parallel data warehouse : Delete or Update? So first I would ask : 1. In general which process is faster? 2. What if we are doing operation on column with Index? 3. Which one…
Siddharth
  • 213
  • 5
  • 14
0
votes
2 answers

How to exit a stored procedure in PDW

I am working in PDW AU5. I am writing a stored procedure that needs dynamic SQL (because of variable database names). So, to prevent SQL injection, I am doing a simple test of the input parameter value to the stored procedure. If the test fails,…
skyline01
  • 1,919
  • 8
  • 34
  • 55
0
votes
2 answers

Execute Dynamic Query in a Loop in SQL

I am trying to execute a dynamic query inside a while loop in SQL/PDW. This query will give me the max/min dates and also the distinct count of dates from a Fact table. I need to execute this for all schemas in my database (all schemas have the same…
Triumph Spitfire
  • 663
  • 15
  • 38
0
votes
1 answer

Linked Server Error for PDW

I am trying to connect to a PDW instance from an SMP server. The linked server is established and I can view the PDW databases from SMP. But when I try to select data from PDW, here's the error that I get: OLE DB provider "SQLNCLI11" for linked…
Triumph Spitfire
  • 663
  • 15
  • 38
0
votes
2 answers

Export All Views to Text Files

There are a number of views in a database on one of our servers. I need to save all the view definitions as text files in the following format: IF OBJECT_ID('<[Schema_Name].[VIEW_NAME]>') IS NOT NULL DROP VIEW…
Triumph Spitfire
  • 663
  • 15
  • 38
1 2
3
4