Re: Best way to increase concurrency when using adopenstatic ?

I am not expert on SQL Server, but I thought I would try to help since noone
else did.

None of this makes sense to me, which is why I want to go to the source. If
you don't have that, we're guessing.

Paul

"Ian Ippolito" <IanIppolito@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:065DDE50-64E0-4C7B-A165-D326BBF19A2F@xxxxxxxxxxxxxxxx
Paul,

What type of lock does it supposedly hold? I don't understand how moving
to
the last record will affect locks,

Do you have a reference to this article?

Unfortunately I can't find the article in my browser cache. But the
article
claimed that in SQL 7.0 a static recordset held a lock on each record as
it
is iterated through with .MoveNext. It didn't specfy the lock type but
that
said that concurrency problems can result because these locks are only
released when the very last record is arrived at. The fix it recommended
was
to go to the last record in the recordset to release the locks and
increase
concurrency (perhaps to avoid possible lock esclalation as each record has
a
.MoveNext done to it? This is a guess/interpretation...the article did
not
mention lock esclation). Do you know if this is true in SQL 2005?

Ian



.

Relevant Pages

  • Re: Rowlock v. optimistic concurrency
    ... A report fetches a lot of rows using the "WITH " syntax (the ... Note that lock timeouts are by default off in SQL Server. ... NOLOCK has nothing to do with optimistic concurrency. ...
    (comp.databases.ms-sqlserver)
  • Re: controlling lock order in transactions
    ... > and the trigger issued a rollback your commit or rollback would error. ... > Andrew J. Kelly SQL MVP ... >> taken) for the duration of the transaction. ... >> find in the clients sp that could be causing the dead lock is the join on ...
    (microsoft.public.sqlserver.programming)
  • Re: Pass-Through Query w/o Record Locking
    ... > Found some documentation on the Progress web site that addresses an SQL ... >> Can you setup a nightly job writes your needed data to a 'warehouse'(OLTP ... >>> looking for but am running into record lock problems. ... >>> modifying. ...
    (microsoft.public.access.queries)
  • Re: Locking pages in memory
    ... the account SQL runs under) the permission to lock pages in memory. ... Server Standard, Enterprise, and Developer editions: Required for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: controlling lock order in transactions
    ... Andrew J. Kelly SQL MVP ... > ROLLBACK TRANSACTION; ... > find in the clients sp that could be causing the dead lock is the join on ...
    (microsoft.public.sqlserver.programming)