June 19, 2017 at 11:15 pm
Comments posted to this topic are about the item Dealing with High Concurrency with Table Hints
June 22, 2017 at 12:28 pm
So, the READPAST hint is potentially useful to prevent blocking, and the risk is that not all records that are expected to be affected, will be affected by the logic of the SQL statement. Am I on the right track?
June 22, 2017 at 2:35 pm
You're on the right track. But note that, like it's highlighted on the documentation, because the SQL Server query optimizer typically selects the best execution plan for a query, it's recommend that hints be used only as a last resort by experienced developers and database administrators.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy