The Formula (FE) and Storage Engine (SE) explained

To be able to optimize DAX queries, you need to know how the formula engine and the storage engine work with them, so how about we let them explain themselves?

Watch the tutorial:

Recommended additional resources

I recommend you to also watch the vertipaq series to learn more about how DAX works behind the scenes.

«

Prev

1

/

1

Next

»

What is Vertipaq and how does it work? Part 1: Data compression

Why is Vertipaq so fast? Part 2: Columnar database

Why is Vertipaq so fast? Part 3: Segment Elimination

DAX Fridays! #126: Understand the Formula Engine and Storage Engine to optimize your DAX queries

«

Prev

1

/

1

Next

»