Ok, thanks. I'll try to solve my problem.

Understood....

GilaMonster (12/19/2008)

Are you sure? You know what the victim is, but without the deadlock graph there's no way to...

Thanks for your help, but I know where deadlock occures. THe problem is I do not understand why! Why two paralel update queries can execute parallel!? It means (by profiler)...

I understand but it is not good for me. I have a million works to do and 100 users (for example) - one of them more "usefull" other less and...

Thanks for your reply! Your advise may help me at save work mechamism, but still I have a problem at get work. I have checked with profiler on two users...

I know. Thanks.

Thanks to all of you!

I do not have any bottlenecks right now. All that I want is to understand is there any simple way to improve SQL server performance and throughput by adding new...

Let me explain my problem:

I have a one table with huge data size (its about millions records and gigabytes in size) and without any foreign keys. My actions are selection...

Thanks for your replies! I will check every suggestion. One more question: what do you think about technology that called linked servers - can it improve performance and bandwidth? I...