After we did massive truncate of data, there is a huge unused space in multiple databases data files, and I wonder what would be the best way of releasing it back. I know most of the experts are against it, I am not talking about single digit GB space, its more 56% unused space out of 800GB data files, and there are many more files in the server.
SQL Version - 2014 Standard ( this cannot be changed, and no more storage can be added)
I know the below options could work, but also potentially cause fragmentation.
DBCC SHRINK(causes massive fragmentation and uses back some space while update status).
- Moving the Primary File Group table to Secondary File Group.
- Adhoc shrink in Chunks (this also causes fragmentation).
Any suggestions above this and new ideas are greatly appreciated.