Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_k_
Starting Member
23 Posts |
 Posted - 2004-05-12 : 15:15:10
|
| We store a big amount of images in our SQL Server DB in several tables, in column of type 'image' . Now we try to make space used by DB smaller by shrinking the images stored in the image fields.After completion of the shrinking process I run 'sp_spaceused' and found that the space occupied by table is close to be the same and most of the new free space is specified as unused. We will never add any new information to this table. Will SQL Server use the unused space of this table for the new data added to the other tables or we have to make SQL Server to reallocate? How we can reorganize the unused space? Thank you very much for any help,a_k_ |
|
|
jharwood
Starting Member
41 Posts |
Posted - 2004-05-12 : 15:45:32
|
| The sysindexes may have not refreshed. Have you run sp_spaceused @updateusage = 'TRUE'? |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-05-12 : 15:53:01
|
| each image can occupy no LESS than one page (8KB) of data. shrinking your images down to less than that won't help you any at all.That's why storing images in SQL server is not recommended. It's far better to store a pointer to that image in a varchar field than storing the actual image in an image field. |
|
|
|
a_k_
Starting Member
23 Posts |
Posted - 2004-05-12 : 16:36:54
|
| Thank you very much for replay.I run sp_spaceused with updateusage option.The average size of images before shrink - 100Kb, after shrink 65Kb. Thank you,a_k_ |
|
|
|
|
|
|
Too big amount of unused table space