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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-11-28 : 01:55:02
|
| Hi All,I am observing some thing strange????I have database where in one of the table I have column with datatype image/binary which allow nullsbut when i took database back up I found size of bak file is huge @ 3 GB (data in that image column is null) but when i again took bkp with out that column size is 1 GB.So shall i conclude that image data type having values null consume space of DB????Tell me wheather i am wrong???T.I.A |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-28 : 11:10:23
|
| there may have been data in the column previously and the reserved space has not been returned yet. compare the used and reserved field values using this query...select reserved, used from sysindexes where indid = 255 |
 |
|
|
|
|
|
problem with image datatype having all values NULL