Whoooo boy, that was a bad pun of a title; I think I may have actually topped Count Rowula. Anyway, today's example is from Lynn Rogala, who was tasked with figuring out how to merge three additional marketing databases into their existing system. The data folks tried just merging the data, but that caused the system to become incredibly slow. After a little bit of digging, Lynn discovered that the original programmers didn't really believe in using the WHERE clause when it came to SELECT statements ...

ResultRecord getDetail(String contactId)
    String sql = "select * from contacts";
ResultSet resultSet = GetResultSetFromSql(sql); while(resultSet.hasNext()) { ResultRecord record = resultSet.next(); if(record.getContactId().equals(contactId)) { return record; } } }