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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-02-19 : 04:53:21
|
| Table Day 1 rows dataspace VITY_TBL 2519882 977776 =========================================================VITY_TBL Day 2 rows dataspace 2519651 985664=========================================================EOD i take rows and data space of the table.my question is based on the table , u can see number of rows decreased on day 2but dataspace increased . how it is happening ..normally if rows decreasing mean dataspace also shud reduced. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-19 : 04:56:18
|
| Not always necessary. It may be the case that some columns which earlier contained NULLs were assigned some values, if there is BLOB column, it might have got updated with bigger size binary data etc.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-02-19 : 05:04:20
|
| what is BLOB Column ?? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-19 : 05:09:52
|
| A column which can contain binary data such as image, music, movies, documents etc.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Table dataspace