Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Locks on tempdb objects

    GilaMonster (4/23/2013)


    If they aren't running in a transaction, those locks will be released as soon as the insert/update/delete completes, so there won't be more and more locks. If they are...

  • RE: Locks on tempdb objects

    GilaMonster (4/23/2013)

    when you have a lot of fine-grained locks in transaction you'll get a problem with accessing data? 🙂

    No. If there are too many locks, SQL will just escalate to...

  • RE: Locks on tempdb objects

    GilaMonster (4/23/2013)


    I think a lot more information is needed to say anything useful. Oh, except for the fact that changing temp tables to table variables will do nothing for locks.

    GilaMonster,...

Viewing 3 posts - 1 through 4 (of 4 total)