Post reply

Preventing concurrent inserts

  • February 26, 2021 at 4:25 pm

    #3850638

    I'd avoid a guid if at all possible.

    Make sure you have an index keyed first on c1, so that determining the max(c1) is a single, quick seek.  An INSERT of a single row shouldn't take too long, so even if it's briefly blocked, I wouldn't expect too much of an issue overall unless you're issuing an extremely high level of INSERTs.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

  • February 27, 2021 at 1:55 pm

    This was removed by the editor as SPAM

Viewing 2 posts - 16 through 16 (of 16 total)

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