Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.
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.