| http://www.w3.org/ns/prov#value | - Page splits are a very bad thing because not only is the index fragmented by page splits, but they also cause SQL Server and the underlying disk system to jump around a lot to find data to be processed and that usually causes degradation of performance.
|