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

Convert SQL script to work on parallel data warehouse

I have SQL script which when executed runs on all database, Get list of all Tables with record count and Index created on that Table. However when I try to run that on parallel data warehouse server , Its giving me error. Because parallel data…
Mahajan344
  • 2,492
  • 6
  • 39
  • 90
0
votes
1 answer

Error Handling in Microsoft PDW

I am in the process of migrating certain stored procedures from SQL Server 2012 to Parallel Data Warehouse (working on Visual Studio 2013). I notice that several SQL Server built in commands are not supported in PDW, for example TRY...CATCH is not…
Triumph Spitfire
  • 663
  • 15
  • 38
0
votes
2 answers

Functions/Synonyms in Parallel Data Warehouse

I know in PDW, functions and synonyms are not supported. Any idea, what's the alternative for these? Thanks in advance.
Triumph Spitfire
  • 663
  • 15
  • 38
0
votes
1 answer

What are automation tools used for datawarehouse testing

In my recent interviews i have come across a common question, did you do automation on your datawarehouse test scripts? I googled about this but didn't get any specific tool name(s) which are used for automating DWH tests.My test scripts are SQL…
Geeme
  • 395
  • 2
  • 6
  • 18
-1
votes
2 answers

Resultset from Facts across different schemas

We have a DB which has several schemas and each schema has a Fact table. I need to prepare a result set with schema name, max(MTH_DT) from Fact and distinct MTH_DT counts from each Fact table. SCHEMA_NAME MAX(MTH_DT) …
Triumph Spitfire
  • 663
  • 15
  • 38
-1
votes
2 answers

TSQL to prepare 15 Min Chunk Data

I am having a warehouse Fact Table containing raw data (Even Duplicate Data) received from vendor through a data feed. I need to prepare the chunk of 15 Min Interval data. How can I best SQL Server query to do this. E.g.Sample Data ID key Date …
Veneet
  • 41
  • 9
1 2 3
4