• Great article.

    I was not able to copy and paste the code into SSMS. Had unicode characters and syntax errors that I could not see.

    I also have lots of tables that have autonumber ID columns as the primary key. I have given up that practice. I query my item table mostly by item number rather than ID. My pallet table by pallet number. It makes sense to put my pages in order by the primary natural key. Change is hard.

    ATBCharles Kincaid