Not All SQL Server Page Splits are Bad

(Tim Ford) Page splits occur when inserting—and in some cases updating—data in a database. If there’s not enough room to insert the new value or deal with the ramifications of the updated value of a key, then an additional page may be added to the leaf level of the index (and depending on the state

Read More - Register for Free Membership