April 22, 2015 at 9:40 am
Hi gurus
I would like to know if the following is possible
I have a DB that I would like to purge info out of it, but I would like to know the size in GB or KB of the information that will be purge BEFORE I can even do that, as you can see I am very new to sql so go easy on me.
Thanks a bunch
April 22, 2015 at 9:52 am
Right-click on the table in SSMS and go to the storage tab. You'll see the size of the table and the number of rows: from that you can calculate the approximate average size of a row. Now run a query that will return the number of rows that will be deleted, and multiply by that by the average row size to get the amount of data that will be affected. Don't forget to take indexes into account as well - you'll find the index size on the Storage tab.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply