The following command shrinks the size of the data and log files in a database. Here is a small example:
DBCC SHRINKDATABASE (Database_Name, 10);
This allows for 10 percent free space in the database.
Visit the DevX Tip Bank
