table sizes  
Author Message
GoogleGroups





PostPosted: Mon Nov 22 18:44:41 CST 2004 Top

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?

--
-Scott Elgram

SQL Server288  
 
 
David





PostPosted: Mon Nov 22 18:44:41 CST 2004 Top

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.

--
David Gugick
Imceda Software
www.imceda.com