This question already has an answer here:
I purged about 100 GB on 200 GB SQL Server v11 DB. The MDF file still show about 200 GB in the file explorer.
Everything looks fine, first tests shows 50% time treatments increase and the backup's size are reduced.
Do you think shrinking is still interesting ? If yes what could be the best way ?
- Release unused space,
- Reorganize pages before releasing unused space (shrink file to : X MB),
- Empty file by migrating the data to other files in the same filegroup.
Index Reorganize/Rebuild, then Update Stats is planned anyway after this operation.
Thanks for help