will convert the columnstore table to a heap.
A column store table is highly compressed and if you want to convert it, you need additional space.
Do I really have to extend the disk size to drop it?
So, yes.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have a clustred Columnstore Index on a big table (5 billion rows), that I want to drop.
So I understand that dropping a clustered columnstore index will convert the columnstore table to a heap.
When I do this, DROP INDEX, I get an error message saying that disk is full.
I am kind of stuck here. Do I really have to extend the disk size to drop it?
will convert the columnstore table to a heap.
A column store table is highly compressed and if you want to convert it, you need additional space.
Do I really have to extend the disk size to drop it?
So, yes.
I found the option WITH (DROP_EXISTING = ON), I could try that and see if there is any difference.