TX creates objects in SQL Server that is not deleted, when they are deleted in TX. Leaving these objects as orphans in the database.
The Cleanup Wizard is okay, but not very user friendly when you need to clean up a database with a long lifespan. The lists of objects and object names are just way too cryptic to make this a good tool.
I hope this can be improved to make it easier to find objects not in use and to identify them clearly as "Good to delete".