T-SQL "WITH NOLOCK"

Ignoring the locks SQL places on tables during transactions can be useful, but be careful:

• http://www.karpach.com/Using-WITH-NOLOCK-T-SQL.htm
• http://stackoverflow.com/questions/686724/sql-when-should-you-use-with-nolock
• http://www.google.co.uk/search?rlz=1C1CHMB_en-GBGB316GB316&aq=f&sourceid=chrome&ie=UTF-8&q=t-sql+nolock