After deleting from clustered columnstore index table, space does not get released according to sp_spaceused


  • Hi, 

    we have sql server 2014, partitioned clustered columnstore index table (100+GB), and when we purged data (several partitions) using regular delete statement (don't ask me why we did not slide partitions out), sp_spaceused reports even less space available vs before deleting data.

    I know that when purging columnstore data, space is not released immediately, but any idea what needs to be done to speed this process up, or to get report about space accurately?



    Wednesday, February 07, 2018 3:15 PM

All replies