here is the explanation
In this case 2 tables r involved. Trainy_let_mast and trainy_let_tran. And primary key has been
defined on 3 columns...
We are trying to analyse a query which involves a inner join between 2 tables.
set statistics time on and
set statistics io on we got...
I just want to add to the observations we made.
We found following blocking situations.
SPID 1 is blocking ---> SPID 2 ---- is blocking ---> SPID...
Thank you very much.
To solve this problem, I think We need to do lot of analysis and study the situation under
which it happens. We will try...
We r using Sql Server 2000.
We have few applications with more than 25 databases in a server. DML operations
happen across databases thru application. Also there is one...
I have setup transaction replication from a remote server to a central server. The connections is a leased line. Due to some problems in leased...
Separate names with a comma.