Business Intelligence: VertiPaq vs ColumnStore Comparison

In this paper, you will read about an investigation of the performance of the two technologies, comparing the performance of both in similar queries. Moreover, in the process of comparing the speed of both engines, we show some best practices about how to improve performance of both DAX and SQL, in the special scenario where you are using ColumnStore indexes.

An SSAS tabular model is an integral part of the architecture of inContact's pay-as-you-go cloud service that provides standard and analytical reporting as part of their service offering. This case study explains how we met inContact's stringent business requirements by designing a tabular solution that runs great on commodity NUMA hardware, in private data centers world-wide.

BI+SQL Server 2016 = sant

Uppdatera dig!

Ta med dig dina BI-kunskaper till  SQL Server 2016.