Monthly Archives: April 2014

Parallel Data Warehouse (PDW) and ROLAP – Part 2

PDW 2012 As promised in my previous post about ROLAP on PDW, here are some more tips, tricks and recommendation for using SSAS in ROLAP mode on a PDW source. Please read part 1 first as most of the tips … Continue reading

Posted in Allgemein | Leave a comment

Discover missing rows of data

PDW 2012 | SQL Server 2012 | SQL Server 2014 If your source data contains a subsequent number without gaps it’s relatively easy to find out if data rows are missing. The approach I’m showing here uses window functions that … Continue reading

Posted in Allgemein | Leave a comment