Can we use in-memory oltp instead of columnstore index for DW queries

Recently when having a chat with a client I was asked if it will be a good idea to replace a view with a static in memory table so that users querying the table for a dashboard will have better performance considering the data will be in the RAM.

Bottom line the best place to do this is by using a regular table with a columnstore index however I figured this is better demonstrated in a Video considering i get asked this question quite a bit.


Please Consider Subscribing