The pain of Real-Time Data Analysis in SQL Server 2016

SQL Server 2016 provides you with a lot of new features and functionality around the ColumnStore index that was introduced back with SQL Server 2012. One of these new features is the ability to create a Filtered Non-Clustered ColumnStore Index on top of a regular Row-Store table. This might sound a bit surprising at first, …

The pain of Real-Time Data Analysis in SQL Server 2016 + read more