Posted by Erland Sommarskog on 11/28/69 11:58

One more thing: how are the INSERT organized with regards to indexes
on the table, specifically the clustered index? If the data comes in an
order that does not agree with the clustered index, you can get a lot of
page splits and overhead.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQLRef - Website Created by Programmer to Programmers
• Prev in forum: formatting for a birth date field??
• Thread view: Re: sql server i/o bottle neck ?

[Reply to this message]