Do I need to compact my SQL Server database?

This is a question frequently asked by those who have used Microsoft Access. This blog posting goes through some great examples to prove that SQL Server can and does automatically reuse space, even after you delete rows.