title: If same table is there in a query multiple times do we have to add WITH (NOLOCK) each time?
body: <p>If same table is there in a query multiple times do we have to add <code>WITH (NOLOCK)</code> each time? So let's say we have a huge query in which same table maybe referenced multiple times then do we have to add <code>WITH (NOLOCK)</code> each time or we can add it once and SQL will ensure that each instance of it is read using <code>WITH (NOLOCK)</code> hint.</p>