Prev: Concatenate with delimiter
Next: decimal problem
From: TheSQLGuru on 28 Apr 2010 09:41
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" <zupan.net(a)gmail.com> wrote in message
news:9b06fe43-b04e-46e1-8a06-65577aec769f(a)g11g2000yqe.googlegroups.com...
> 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