In this tutorial I will show how to optimize the space used by databases.
The optimization of the space is done in two stages:
- On the database: internal data optimization
- On files: reducing the size of the files on the disk.
It is recommended that you perform these operations after deleting a large amount of data.
Reduce the size of the database
Reduce file size
As for the size of the database, the operation is to do with SSMS.