Posted by Erland Sommarskog on 10/01/11 11:33

Matik (marzec@sauron.xo.pl) writes:
> Well, I can say, that the update is done only in one statement, and
> it's over the where id = any_number condition .

That may be enough.

> Do You think, that removing the index (because this acctualy not
> increases perfomrance, by such a small table) which is put on
> fk_dtsIndex field could generaly solve the problem?

Yes, that is my theory.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: error handling and bulk insert
• Prev in forum: Re: Help needed by deadlock problem
• Thread view: Re: Help needed by deadlock problem

[Reply to this message]