I was looking at your blog posts and thought I'd point out a slight error in the second. Number 4 (4. Using pre-ANSI JOIN syntax) is slightly incorrect. ...

I have recently blogged about 10 common mistakes Java developers make when writing SQL. These mistakes apply to all other developers (including SQL developers) as well, of course:

http://blog.jooq.org/2013/07/30/10-common-mistakes-java-developers-make-when-writing-sql/[/url]

http://blog.jooq.org/2013/08/12/10-more-common-mistakes-java-developers-make-when-writing-sql/[/url]

I'm quite surprised that the "holy grail of paging" doesn't mention the (granted a bit less popular) "seek method" as described here:

http://blog.jooq.org/2013/10/26/faster-sql-paging-with-jooq-using-the-seek-method/[/url]

Take the following example:

SELECT TOP...