SQL Server, How to choose a clustered key value and the Last Page Insert Latch Contention problem
Hi Guys, Today you are the data architect ! your first task is to design a table from scratch. But...how do you choose the clustered key value? It sounds easy but rember that your decisions will have a lot of consequences for the long life of the project ... and you can't go wrong! How to choose a clustered key value Today let's review some theory .. A good Clustered key must be narrow . It is not only a question of data occupation (today storage devices are spacious) but a lot of data takes time to be read. We always consider that the value used will be used not only in the clustered key. It will in fact be used in any non-clustered index. So for example fields Id and page_id, category_id must have the same data type. Normally you should use a surrogate key value (like an ID identity, a progressive numerber) instead of a natural key (whose values are formed by attributes that exist and are used in the external world, for example surname+name). A surrogate key value ca...