Sometimes a quick script is just what the doctor ordered.
I recently had the task of packaging up a database to ship it offsite. This database had some size to it, approximately 200GB with 6 tables. While looking at the tables, I noticed that though they were relatively narrow, each had ~22 million rows in them. In my environment this wasn’t wild or out of the ordinary, however, I did think that the disk space usage was a little out of whack given what I was seeing. So, I set out to see if I could make the database smaller so that it was easier to transport.