The database is managed using MSSQL.
The database has a large capacity (about 300GB) and I want to compress the database every day, but I am not sure how to determine the design of "free space to leave after compression".
I would appreciate it if you could teach me the effects of setting the minimum 1%.
Answer # 1
If you decrease the number, file fragmentation will occur more easily.
If you want to compress every day, it is recommended that you leave a free space of about the amount that increases per day + α.
- [sql server/vscode/ms-sql] about creating schema and adding tables
- sql server - about conditional expressions in dynamic sql
- sql server - please tell me about exists in sql
- [sql server] is the database generated from the script the same as the database from which it was generated?
- sql server - how to deal with database restoration to microsoft sqlserver downgrade version?
- about the database on the server
- sql server - what is "$ip" and "$port" in "php artisan serve --host=$ip --port=$port"?
- sql server: in management studio, when i try to open table data in 200-line edit mode, the debugger comes up
- sql server - is it possible to use inner join multiple times in an update statement that uses sqlserver inner join?
- about sql condition specification
- sqlite - about database connection [monaca]
- about the space between elements in html and css
- regarding the case where the sql server session remains (in the usage monitor of management studio)
- [sql server] how can i register data that does not have a screen?
- sql server - [sql statement] how to prevent output if there is a value that exists in a specific table
- mongodb - about the database design of the two-choice question app
- i want to display the sql statement error of sql server on the net screen
- about building failover clustering in windows server 2019
- i want to convert the 4-digit number stored in sql server to the time format (hh:mm) and save it (since it is converted to time,