O'Reilly logo
  • Dustin Waybright thinks this is interesting:

So far, the values of the clustering key were sequential. What happens if they are not?


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


If the values in the clustering key are not sequential, SQL Server will have to do multiple page splits as the values are entered into the index which will lead to greater fragmentation.