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
pelegHi
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...
> >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
>
>|||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...
> >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
>
>