Hi,
Got a 2TB ss2014 DB and applied Clustered Column Store Indexes (compressed) which brings the data size down to 350GB. Understanding head room + 100% additional space is required for INDEX REBUILDS, there is still vast amount of unused space.
Primary data file initial size was 1TB, now 900GB empty and usual DBCC SHRINKFILE(, 512000) is not working. DB is in simple recovery mode and on Fusion-IO storage.
Any ideas why I cannot shrink data file below initial size? Thanks