can a Microsoft SQL database or table be compacted?

Too late for edit. I hope there are no hard feelings. I hope to be in your shoes one day - (Be a well paid DB admin. Or well paid something anyway)