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
