Sidd's SQL Solution

New Year comes with a lot of new hopes, resolutions and opportunities and hence I also took this opportunity to write a post, which is also in line to this saying. As we all know very well that in today’s world the amount of data any application is gathering is huge and growing exponentially and so does the size of the database holding that data and ultimately the storage hosting that database. Though per dollar cost of storage comes down every year, we still need to be prepared for future growth expected for our databases at least by a year in advance to avoid any surprises because of disk spaces. Though this sound as basic part of all IT planning but answering how much space would be required can be tricky. It may not be possible to answer in certainty on how much space is required in future but we should at least have close approximates in hand. Implementation Same scenario also came to me recently and hence I developed my version of T-SQL script, which not only gives gr