Are column store tables now the vendor default method for Kimball Data Warehouse tables with Dim and Facts for On Premise?
I know in the cloud, Microsoft automatically recommends Azure Data warehouses use column store. How about on premise? Is this the vendor solution, or should I conduct row based testing?
We have SQL 2016, 50 cores, 200GB of RAM. Database consumes 500GB each year.