pooyan_pdm (8/8/2012)
And about the update I don't know what you think of a index key update but it' effects on page splits and fragmentation is the same as another insert.
An update can only cause page splits in an index if it increases the size of the columns used as key or include. That's null-> non-null or increasing the amount of data in a variable length column.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability