Hi,

My database’s actual size is 3+ GB, but due to this Unused (Reserved) space it currently shows as 12+ GB and grows at a rate of 150MB per every 3 hrs.
When I check the space usage by Individual tables, I saw a table <xxx> having reserved space of around 8 GB which contains only 2 columns of which one is an integer (primary key, clustered index) and the other is an image data type (BLOB) field.
The image size would be some KB or to a max of 1-2MB and once it is read, it gets automatically deleted from the table.
There are currently less than 20 rows in the table.

Is there any way to get rid of this unused space other than deleting and recreating the table, cannot be done as it’s a prod environment (24*7).

Any help on this is highly appreciated.

Thanks,
Pavan.