• If you want speed, you should use nolock.  If you absolutely must have the most up to date data, don't use nolock.  The difference being that a Select without nolock will wait for any uncommmited transactions to clear before selecting the data.  With nolock it will give you whatever is commited to the database.

    cl

    Signature is NULL