[dba-SQLServer] Index Fragmentation

Francisco Tapia fhtapia at gmail.com
Mon Jun 23 16:30:39 CDT 2008


Hey Arthur,
  I'm not ignoring your post, but have gone out to do some re-search in
between my normal tasks :).  I'll let you know what I find.

--
Francisco

On Mon, Jun 23, 2008 at 4:30 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Now I am very puzzled. After noticing a number of seriously fragmented
> indexes, I ran a job over the weekend, using the following syntax:
>
> ALTER INDEX IX_900_PortfolioSummary__PPCID_PortID ON
> dbo.[900_PortfolioSummary] REBUILD
> etc.
>
> To my surprise, the indexes in question remain just as fragmented as they
> were before the job. Can anyone advise me why this is so? I thought that a
> REBUILD completely rebuilt the index with no fragmentation.
>
> Thanks,
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list