I was looking around at ways to optimise asp.net over the last few days and ran across this article about using ROW_NUMBER(), which is quite good. There were a few aspects of it missing that I had to do a little more work to look up. I tracked down some