A ever-increasing Clustered Key value doesn’t scale!

You know all the best practices how to choose a Clustered Key value? A good Clustered Key value should have the following 3 properties: Narrow Static Ever Increasing Let’s have a more detailed look on all 3 properties, and why an ever increasing value doesn’t really scale in SQL Server. Narrow A Clustered Key value …

A ever-increasing Clustered Key value doesn’t scale! + read more