It's not a great article, as some of the clarification comments and discussions are surfacing. It is an import topic. Often reading the database documentation directly around Transaction Isolation and Locking sections will be more precise, complete and be specific for the database/version you are using.