The NOLOCK Chronicles

The use of READ UNCOMMITTED isolation and its evil lock hint offspring NOLOCK are the root cause behind 9/10 heart attacks suffered by DBAs from the stress of their jobs. In this lightning talk, we will do our best to convince the SQL Developer and Business Intelligence communities to avoid using this nasty practice through the use of real-world examples and unexpected behaviors and instead provide alternative solutions.