Checklist for Memory Optimizations in PowerPivot and Tabular Models
This article contains a short checklist of what you have to do in order to optimize the memory used by… Read More »
VertiPaq vs ColumnStore Comparison
SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help… Read More »
Memory Settings in Tabular Instances of Analysis Services
Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines.… Read More »
Optimizing High Cardinality Columns in VertiPaq
VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the… Read More »