Jess Pomfret looks for old tables:
There are many reasons why you might end up with tables named
something_oldin your database. Perhaps this is part of your decommission strategy, to rename them to make sure they really aren’t in use. Or, it could be because you need to make schema changes, you can rename the current table and create a new table with the desired schema. But, the key to this blog post is when you then forget to come back and clean these tables up. We can easily find them with a dbatools command.
Read on to see how you can use dbatools cmdlets to find and remove these deprecated tables.