From: TheSQLGuru on
Can you provide your table create script including all indexes, as well as
the update statement you are using?

The actual query execution plan would be helpful too.

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"simon" <> wrote in message
> Hi,
> i have many different users(50) at the same time, which create updates
> on the same table - each user on different rows.
> Is it possible that all updates are executed at the same time?
> Because, now, I guess, when first user create update, the all table is
> locked and others must wait.
> What setting should i put into my update statement, that it won't
> block other users to update their rows?
> What is the best scenario?
> Thank you,
> Simon

First  |  Prev  | 
Pages: 1 2
Prev: Concatenate with delimiter
Next: decimal problem