article

Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.  Read more

article

Data Model Size with VertiPaq Analyzer

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines. Analysis Services 2012 can be installed in different ways and the new Tabular instance has new memory settings that are…  Read more

article

Regular and limited relationships in Power BI

This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX.  Read more

article

Formula engine and storage engine in DAX

This article explains the roles of the formula engine and of the storage engine used to execute DAX queries.  Read more

article

Optimizing memory settings in Analysis Services

This article describes the memory configuration in SQL Server Analysis Services and Azure Analysis Services. Modifying these settings may impact performance and memory errors.  Read more

VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the more expensive parts of a table. If you cannot remove a high cardinality column from a table, by using the…  Read more

article

Using calculation groups or many-to-many relationships for time intelligence selection

This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships.  Read more

We presented a few session at SQLBits and the video of these sessions are available. This is the list of sessions available from SQLBits 8 and SQLBits 9 – just click the link on the title and jump to the…  Read more

article

DIVIDE Performance

The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis.  Read more