Hello,
I am trying to plan a major change in one of my databases and would like
to figure out how large a particular table will be.
Back when this particular database was set up (not by me) it was set up
with a table that held image files. Sense then this table has grown to
about 1.5 million records, which is also 1.5 million images. This huge
table is taking almost 15 hours to back up. What I am going to do is take
each of these images and put them back in file form on a hard drive and
reference them by a field in the table. This is probably the way it should
have been set up to begin with but it's too late now. I have already
written a program that will do the work but I would like to get a rough idea
of how large the end table will be. Can anyone help here?
SQL Server >> table sizes
> Hello,
> I am trying to plan a major change in one of my databases and
> would like to figure out how large a particular table will be.
> Back when this particular database was set up (not by me) it was
> set up with a table that held image files. Sense then this table has
> grown to about 1.5 million records, which is also 1.5 million images.
> This huge table is taking almost 15 hours to back up. What I am
> going to do is take each of these images and put them back in file
> form on a hard drive and reference them by a field in the table.
> This is probably the way it should have been set up to begin with but
> it's too late now. I have already written a program that will do the
> work but I would like to get a rough idea of how large the end table
> will be. Can anyone help here?
You can do SELECT SUM(DATALENGTH(imagecol)) From Table to get the total
number of storage bytes used for the image data.