I was trying to retrieve the exact amount of bytes required by a clustered columnstore index in MSSQL. Unfortunately I get different result from sp_spaceused compared to a simple query on sys.allocation_units. Here the simple script: Here the sp_spaceused result: Then I try to get the amount of occupied pages querying directly sys.allocation_units using this query: And of course the