Enabled page compression on a big table around 1 TB, and after the compression finished, I was able to see 56 percent free space in the data file.
I was thinking that any new transactions happening on the database would be playing inside this available free space of 56 percent.
Today, i found the disk on which data file resides ran out of disk space.
But, the data file still has that 56 percent free space.
Can someone tell me, why the free space is not getting utilized?