Partitioning tables in SQL Server provides improved query performance. Lets me share a simple example:- Imagine you have a large sales table with millions of records spanning several years.

In SQL Server 2012, we introduced the memory optimized columnstore index. This resulted in huge query performance improvements but columnstore indexes had one significant disadvantage – they couldn’t ...

While the integration of the Power Query engine into Analysis Services Tabular 2017 and Azure Analysis Services with modern data sources will certainly bring a lot of benefits, I think it’s fair to ...