What You Should Know About SQL Server 2016 ColumnStore Indexes

One of the exciting features for data warehouse queries in SQL Server 2012 was the columnstore index. These are designed to provide good performance on analytical queries without the need to explicitly specify indexes. There were, however, many restrictions for their use, including: Columnstore indexes had fewer supported datatypes. Columnstore indexes were Non-updatable–once created, the table would become read-only. … Continue reading What You Should Know About SQL Server 2016 ColumnStore Indexes