Is your MS-SQL database growing for some unexplained reason?

If you are using DotNetNuke, you may experience growth in your database that you just can't explain. The problem may be that you are suffering from Database File Fragmentation (well, that's what I call it anyhow.) As you add and remove records, the database file gets fragmented and empty space is left between the records. The result is a database much larger than what you really need.

To remedy this problem, you need to execute the following SQL against your database:

DBCC SHRINKDATABASE databasename

I did this for one of my own clients recently and reduced the size of the database to 10% of the original size.