#{ SQL: Explicación visual de Joins }

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

#{ Java: Convertir un resultSet a ArrayList }

public ArrayList resultSetToArrayList(ResultSet rs) throws SQLException{
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    ArrayList results = new ArrayList();

    while (rs.next()) {
        HashMap row = new HashMap();
        results.add(row);

        for(int i=1; i<=columns; i++){
          row.put(md.getColumnName(i),rs.getObject(i));
        }
    }
    return results;
}

http://amcubes.com/2009/02/20/converting-resultset-into-arraylist/

#{ SQL > ORM, interesante artículo }

http://www.cforcoding.com/2009/05/orm-or-sql.html
http://stackoverflow.com/questions/494816/using-an-orm-or-plain-sql/494853#494853

#{ Reiniciar PK autoincremental }

Para SQL server:

DBCC CHECKIDENT (NOMBRE_TABLA, RESEED, 0)