InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 03:30:47 GMT20http://www.sqlservercentral.com/Forums/Topic1118408-2904-1.aspx?Thu, 09 Feb 2012 14:06:00 GMTpkrudyszhttp://www.sqlservercentral.com/Forums/Topic1118408-2904-1.aspxWhat would a treshold (in the number of index pages), below which we should not worry about fragmentation and don't have to rebuild?Thu, 09 Feb 2012 10:04:12 GMTpkrudyszhttp://www.sqlservercentral.com/Forums/Topic1118408-2904-1.aspxNo offense intended, but when I refer to "external fragmentation", I refer to fragmentation outside of SQL Server's control; even if SQL Server reports page 1's next page is 2, whose next page is 3, at the OS level, perhaps they're on three completely different areas of the disk. Perhaps even the OS level is contiguous, but the SAN (Meta)LUN actually has each on noncontiguous areas of the platters.In either case, the head has to move more than it should to read three pages.Wed, 01 Feb 2012 14:13:24 GMTNadrekhttp://www.sqlservercentral.com/Forums/Topic1118408-2904-1.aspxIn an example #2 to accomodate one month of inserts into 12 months table, how do we figure out that fillfactor might be 80-84%? We insert 100/13= 8% of the data, so we would reserve 8% of the space.Fri, 01 Jul 2011 16:04:16 GMTobulayhttp://www.sqlservercentral.com/Forums/Topic1118408-2904-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72443/">Stairway to SQL Server Indexes: Step 11, Index Fragmentation</A>[/B]Wed, 01 Jun 2011 14:49:14 GMTDavid Durant