Post reply

Dealing with High Concurrency with Table Hints

  • June 19, 2017 at 11:15 pm

    #322185

    Comments posted to this topic are about the item Dealing with High Concurrency with Table Hints

  • June 22, 2017 at 12:28 pm

    #1947830

    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

    #1947844

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply