Posted - 11/11/2013 : 18:41:47
| Hello guys
I'm SQL Developer and SQL admin in my company. I'm having problem desfragmenting some index in my database and i did everything always do.
but the indexes stil have the same fragmentation over 80 percent in many cases. following some examples of what I do.
1- ALTER INDEX all ON dbo.salesorder REBUILD
2- UPDATE STATISTICS dbo.salesorder WITH FULLSCAN;
When this does not solver the problem i Execute the following sentence
for evry index CREATE NONCLUSTERED INDEX IX-Index_name ON dbo.SalesOrder
-- Index field
--) WITH DROP_EXISTING
But the fragmentation is the same
how can I reduce the fragmentation to 0 or the lower value under 30 percent. What i am doing wrong.