SQL Server Performance

Rebuild/Reorganise doesn't work

Discussion in 'Getting Started' started by Marian, Apr 10, 2011.

  1. Marian New Member

    Hello all.
    I am running an Sql Server 2008 instance. I have a table in which I am inserting rows (at a slow rate - one insert/couple of seconds).
    The fill factor is 50%.
    Also I have noticed that the fragmentation of my table is at 95%. I've tried to rebuild and to reorganise but I can't seem to take it below 40%.
    Can you please tell me why? I mean shouldn't be 0%?
    Thanks in advance
  2. Luis Martin Moderator

    Welcome to the forums!!
    What kind of indexes do you have in that table?
  3. FrankKalis Moderator

    Also, how many rows does this table contain?

Share This Page