Greg Robidoux checks for free space:
One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be used to shrink data files as needed if there is a lot of free space in the files.
In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.
Click through for several techniques.