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 from MSSQLTIPS they take a look at a few ways to find the current free space within a database, so you can better manage your database files.... Read More