Column store index on a large fact table
move to SQL Server 2014 that offers updateable clustered columnstore index.
if stuck to 2012, use partition switch to update the nonclustered columnstore index.