• Good series of articles Chris. I especially appreciated that you got the "physical ordering" thing right. That is the source of much confusion, and if I were to make one recommendation it would be to emphasize the fact that clustered indexes do not maintain the physical ordering of data pages on disk.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/