Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to SQL Server Indexes: Step 13, Insert Update Delete Expand / Collapse
Author
Message
Posted Thursday, July 7, 2011 2:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 23, 2012 10:54 AM
Points: 8, Visits: 23
Comments posted to this topic are about the item Stairway to SQL Server Indexes: Step 13, Insert Update Delete
Post #1138527
Posted Wednesday, July 13, 2011 12:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 6:30 AM
Points: 9, Visits: 77
Arcticle has double header
Post #1140757
Posted Wednesday, February 29, 2012 5:38 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:09 AM
Points: 846, Visits: 471
You have a contradiction when you talks about page splits on inserts.

>>
Ascending Sequence:...Once a page becomes full, it stays full; resulting in little or no internal fragmentation.

Descending Sequence:...The internal fragmentation is the same as
the ascendingsequence scenario; at or near 100%.
<<

Either Ascending should be "at or near 100%" or Descending should be "little or no fragmentation".


------------
Buy the ticket, take the ride. -- Hunter S. Thompson
Post #1259480
Posted Wednesday, February 29, 2012 6:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
I 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.

"Keep Trying"
Post #1259506
Posted Wednesday, February 29, 2012 11:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 10, 2012 1:26 PM
Points: 19, Visits: 120
If a page contains ghosted records will it still split on insert?


Post #1259749
Posted Saturday, July 7, 2012 11:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, June 23, 2013 10:39 PM
Points: 231, Visits: 506
There is a DML trigger defined on the table.


Can you please let me know if this in actually cause delete/insert for updarte? I couldnt see this behaviour.


GulliMeel

Finding top n Worst Performing queries
Improve the performance of Merge Join(special case)
How to Post Performance Problem -Gail Shaw
Post #1326462
Posted Thursday, September 6, 2012 11:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 9:18 PM
Points: 1, Visits: 56
great 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.

Post #1355742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse