Want create site? Find Free WordPress Themes and plugins.

Simple way is to have a log table, updated nightly. Just create a table and a stored proc as below and have a job which runs it every night.

The example here runs the size query twice for two different databases on the same server. You can then have a simple report off the back of this showing the growth trends over time and on a weekly basis for the largest and the fastest growing tables.

Table:

Procedure:

 

Did you find apk for android? You can find new Free Android Games and apps.

Leave a Comment