Search Results | SQL Server Performance Forums

Hi 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...

Thread by: rrl_sudha, Jun 27, 2007, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi We are trying to analyse a query which involves a inner join between 2 tables. with set statistics time on and set statistics io on we got...

Post by: rrl_sudha, Jun 25, 2007 in forum: General DBA Questions

I just want to add to the observations we made. We found following blocking situations. SPID 1 is blocking ---> SPID 2 ---- is blocking ---> SPID...

Post by: rrl_sudha, Jun 20, 2007 in forum: General DBA Questions

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...

Post by: rrl_sudha, Jun 18, 2007 in forum: General DBA Questions

We r using Sql Server 2000.

Thread by: rrl_sudha, Jun 17, 2007, 7 replies, in forum: General DBA Questions

Hi, We have few applications with more than 25 databases in a server. DML operations happen across databases thru application. Also there is one...

Thread by: rrl_sudha, Jun 17, 2007, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hi 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...