Enhanced ColumnStore Indexes in SQL 2014
By Lori Brown | Miscellaneous , SQL Administration , SQL Server
Available in SQL 2012 & 2014 Enterprise Edition ColumnStore Indexes were introduced in SQL 2012 and are designed to improve performance in data warehouses. These indexes are good for batch processing and read only queries that use large data sets. Tables that are bulk loaded are good candidates. ColumnStore Indexes stores data in a columnar […]
Continue reading