Stairway to SQL Server Indexes: Step 13, Insert Update Delete

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by David Durant » Stairway to SQL Server Indexes: Step 13,...

Stairway to SQL Server Indexes: Step 13, Insert Update Delete

Rate Topic

Display Mode

Topic Options

Author

Message

David Durant

Posted Thursday, July 07, 2011 2:18 PM

Forum 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

dronusoid

Posted Wednesday, July 13, 2011 12:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 5:18 AM
Points: 9, Visits: 67

Arcticle has double header

Post #1140757

G Bryant McClellan

Posted Wednesday, February 29, 2012 5:38 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 818, Visits: 431

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

ChiragNS

Posted Wednesday, February 29, 2012 6:16 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

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

colinallen@hsbc.com

Posted Wednesday, February 29, 2012 11:51 AM

Grasshopper

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

Gullimeel

Posted Saturday, July 07, 2012 11:38 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, January 17, 2013 1:46 AM
Points: 231, Visits: 505

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

xpboyzcx

Posted Thursday, September 06, 2012 11:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 8:06 PM
Points: 1, Visits: 32

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 »

Permissions