I’ve done several search on here and the google and can’t find anything referencing the ability or lack there of for sql hints. In particular I hit a rather busy database where the data I’m pulling back really doesn’t need locking so a dirty ready is fine and much faster but I don’t see any method for adding “WITH (NOLOCK)” hint to table joins. Is this something possible and I’m just googling for the answer wrong or is it something nobody else does?
Thanks!