Lesson Learned #349: ColumnStoreIndex in a Temporary Table

Today, we received a service request where our customer got a performance issue reading 20 millions of rows in a temporal report in PowerBI. They provided to their final users multiple ways to filter...