Scenario Proposal

While working on different database projects I usually find it very necessary to perform a data sizing exercise on all tables focusing mostly on the number of rows in order to determine a growth factor of each table. This kind of information is useful in performing long term planning of growth and scalability of the data that we are managing.

Out of an exercise like this one we can also determine future needs for data archiving.

Continue reading DATA sizing or SQL Server Rowcount without doing a table scan →