Why the RLS bitmap default just went up 4x
Row-level security quietly switches strategies once a table gets big enough. A recent default change moves that line from 128K rows to 512K, and the reason it is not 2 million is a nice bit of engineering.
Tag: Analysis Services
Analysis Services Memory Tip (processing partitions)
The Tip: Convert calculated columns in your model to physical columns (where practical). The Detail If you encounter memory issues when processing partitions in an Analysis Services (AS) database, one option you might consider to resolve this is to convert calculated columns in the offending tables to physical columns. When processing partitions, the AS engine … Continue reading Analysis Services Memory Tip (processing partitions)
Tip to speed up Direct Query
This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip is to set relationships to use INNER JOIN rather than LEFT OUTER JOIN in the model. Once … Continue reading Tip to speed up Direct Query