I have a large table with 30 columns in MSSQL 2014. The data will be inserted in bulks several times a day and the data should be kept for a month.
The purpose of it is to select aggregated queries. So it seems that Clustered Columnstore index is perfect for this. Except that one column is varchar and holds URL values that usually don't repeat. Will it work well with Columnstore? I worked with it , but only on data that hold numbers or repeating strings (like domain).
UPDATE 1. For purpose of importing and purging the table will be partitioned. 2. I don't have the exact DDL right now, because we are at the design stage. Thanks