1. What is the difference between sp_clean_db_free_space and DBCC SHRINKFILE?
sp_clean_db_free_space cleans all pages in all files of the database.
DBCC SHRINKFILE: Shrinks the size of the specified data or log file for the current database, or empties a file
by moving the data from the specified file to other files in the same file group.
Comments
Leave a Comment