ColumnStore Segment Elimination
ColumnStore Indexes are great! They are a real performance booster for Data Warehousing and Reporting workloads. In combination with Clustered ColumnStore Indexes you get a huge compression benefit over regular RowStore Indexes (Clustered Indexes, Non-Clustered Indexes). And creating a Clustered ColumnStore Index is quite easy: CREATE CLUSTERED COLUMNSTORE INDEX ccsi ON TableName GO But is …
