Clustered and non-clustered indexes, the way I wish someone had explained them
Why every table wants a clustered index, how to pick the column, what fragmentation actually costs, and the hidden write-amplification of getting it wrong.
Why every table wants a clustered index, how to pick the column, what fragmentation actually costs, and the hidden write-amplification of getting it wrong.