• Be aware that you can get duplicate data back in a query using NOLOCK.

    Itzik Ben Gan demoed this and you can find a code example here.

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

    --Dave