InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:12:27 GMT20http://www.sqlservercentral.com/Forums/Topic1418779-1550-1.aspx Thank youTue, 12 Feb 2013 14:04:52 GMTzihttp://www.sqlservercentral.com/Forums/Topic1418779-1550-1.aspxThe most important thing here is not the amount a fragmentation but rather the ratio of fragmentation to pages. If you have 4 pages with 50% fragmentation I would not worry about there being a problem. If I have 1000 pages with 50% fragmentation then something needs to be done!This is a situation whereby understanding the collective information presented on the screen is a great deal more important than seeing a single number and thinking the world is going to end!Tue, 12 Feb 2013 08:06:00 GMTkevaburghttp://www.sqlservercentral.com/Forums/Topic1418779-1550-1.aspxLet me guess, tiny table, 2 or 4 pages in size.Tue, 12 Feb 2013 01:21:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1418779-1550-1.aspxDear ExpertsI have made a tracing file, then run tuning advisor. The recommendation shows a lot of indexes. I looked at the fragmentation for some indexs and I found it 50%. I made rebuild.I OPEND THE FRAGMENTATION AGAIN AND FOUND IT STILL 50%any idea why it remains as it is after rebuilding index.Thanks lotTue, 12 Feb 2013 01:05:57 GMTzi