Questions tagged [join-hints]

(Asked on: tuning in sql server - views. Sorry, I needed to review my post). I need to add hint in the join (force using index on ID when doing the join), and on the select (force using index on name for the where clause), as last query mentioned in…

I have some ad-hoc reporting users hitting some SQL Server views. Occasionally the read locks taken by these users for particularly lengthy queries causes trouble elsewhere in the system. I am considering adding some strategic with(nolock) hints to…

We have a query in our system that has been a problem in the amount of logical reads it is using. The query is run often enough (a few times a day), but it is report in nature (i.e. gathering data, it is not transactional). After having a couple of…