fill factor

i have changed a fill factor of a table which wont be updated any more.
i gave all the index+primary key ==>> fill factor=100%
and it seems like i have lost rows! is this possible?
the data is :
===================================
rows size index size
before 4,375,000 4GB 1.65GB
after 4,331,000 2.9GB 1.1GB
thnaks in advance
peleg
Hi
I assume this is from sp_spaceused which may not be accurate. Did you run
DBCC UPDATEUSAGE first?
John
"pelegk1" <pelegk1@.discussions.microsoft.com> wrote in message
news:EA0F7254-EFF4-464B-B3B1-72641A07DE4D@.microsoft.com...
>i have changed a fill factor of a table which wont be updated any more.
> i gave all the index+primary key ==>> fill factor=100%
> and it seems like i have lost rows! is this possible?
> the data is :
> ===================================
> rows size index size
> before 4,375,000 4GB 1.65GB
> after 4,331,000 2.9GB 1.1GB
> thnaks in advance
> peleg
|||nope
i looked at it before and after using the
"view->takpad" in the enterprise manager
can this be the problem?
"John Bell" wrote:

> Hi
> I assume this is from sp_spaceused which may not be accurate. Did you run
> DBCC UPDATEUSAGE first?
> John
> "pelegk1" <pelegk1@.discussions.microsoft.com> wrote in message
> news:EA0F7254-EFF4-464B-B3B1-72641A07DE4D@.microsoft.com...
>
>
|||sorry my mistake i have compared 2 tables with similar names by mistake
everything ok
peleg
"John Bell" wrote:

> Hi
> I assume this is from sp_spaceused which may not be accurate. Did you run
> DBCC UPDATEUSAGE first?
> John
> "pelegk1" <pelegk1@.discussions.microsoft.com> wrote in message
> news:EA0F7254-EFF4-464B-B3B1-72641A07DE4D@.microsoft.com...
>
>