As SQL Server DBAs, we always take care of one of the most important things for the business, the data. In some cases, applications can get quite complex, and you end up with a ton of database tables scattered around your SQL Server instance(s). This might lead to a few inconveniences, such as:
- Knowing how your data behave every day, in terms of growth trends (space and/or amount of rows).
- Knowing what database tables require (or will require) a particular/different strategy to store the data because it is growing too fast.
- Knowing which of your database tables take too much space, possibly leading to storage constraints.