How does SQL Server determine the order it takes locks in while selecting a table?
How does SQL Server determine what order to lock pages in while doing INSERTs and SELECTs a


Undetermined - done by internal processing and depending on query optimizer output.


  and how can you modify this behaviour?


Control your isolation. If you read in order to write, tell SQL Server to immediately get a write lock. Point closed.