SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by David Durant / Stairway to SQL Server Indexes: Step 13, Insert Update Delete / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:59:15 GMT20RE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxgreat post.i read it through 1 to 15.but there is some mistake.for example,10th's list 2 is same as list one,which should be create table and load data instead of create view.and 15th,guildline,the explanation of why use include column is mistake.Thu, 06 Sep 2012 23:16:21 GMTxpboyzcxRE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspx[quote]There is a DML trigger defined on the table. [/quote]Can you please let me know if this in actually cause delete/insert for updarte? I couldnt see this behaviour.Sat, 07 Jul 2012 11:38:30 GMTGullimeelRE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxIf a page contains ghosted records will it still split on insert?Wed, 29 Feb 2012 11:51:35 GMTcolinallen@hsbc.comRE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxI think all the author is trying to say is that in both the cases there will be little de-fragmentation. So overall fragmentation will be near to 100.Wed, 29 Feb 2012 06:16:21 GMTChiragNSRE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxYou have a contradiction when you talks about page splits on inserts.&gt;&gt;Ascending Sequence:...Once a page becomes full, it stays full; resulting in little or no internal fragmentation.Descending Sequence:...The internal fragmentation[b] is the same as [/b]the ascendingsequence scenario; at or near 100%.&lt;&lt;Either Ascending should be "at or near 100%" or Descending should be "little or no fragmentation".Wed, 29 Feb 2012 05:38:48 GMTG Bryant McClellanRE: Stairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxArcticle has double headerWed, 13 Jul 2011 00:36:04 GMTdronusoidStairway to SQL Server Indexes: Step 13, Insert Update Deletehttp://www.sqlservercentral.com/Forums/Topic1138527-2904-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72445/">Stairway to SQL Server Indexes: Step 13, Insert Update Delete</A>[/B]Thu, 07 Jul 2011 14:18:16 GMTDavid Durant