this should help you started:

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

in addition a new article about indexes:

http://www.sqlservercentral.com/columnists/lPeysakhovich/indexcreationguidelines.asp

and the follup up discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=163&messageid=119673&p=2

I guess the installer comes from which language edition you bought from Microsoft.

1)If this is for use in a TRIGGER, I must mention that the triggers fires only once per command/set. So if inserted contains more than 1 ai_id (like 1,2,3)you will...

Rewrote you query a little to use join syntax for readability+performance

Delete dbo.table_A

FROM dbo.table_A A /*SERVER A*/

INNER JOIN dbo.table_C C /*SERVER A*/

ON a.edfoid = C.edfoid

AND  a.IsLInk = convert(bit,0) /*in case of...

sp_prepexec is explained a bit here:

http://jtds.sourceforge.net/apiCursors.html

Normally used by Ado (since it uses cursors to retrieve data)

Normally it would be like

sp_prepare..

sp_execute.. parameter query

sp_execute..parameter query

sp_execute..parameter query

sp_execute..parameter query

sp_unprepare

A one time query doesn't...

Does it happen at set times? Perhaps a job, heavy querie, network congestion got in the way.

Is it reproducable (same parameters, ....)?

You can still increase the timeout of the command...

Perhaps this:

http://support.microsoft.com/kb/q230393/

only minimally logged (about the command, not individual changes)

In addition, the Bulk-Logged Recovery model only allows the database to be recovered to the end of a transaction log backup when...

Process A was waiting on a lock to be released by Proces B

Process B was waiting on a lock to be released by Process A

-> infinite loop

SQL Server then picks a...

You could try covered indexes (index on all necessary fields)

Quite logical:

1) Tempdb has to increase in size

2) Databases are checked and all transactions that were running when the service was shutdown are being rolled forward/backward

3)All buffers are being refilled (cache hit...

Microsoft certainly has a best-practices stored in here:

http://www.microsoft.com/technet/prodtechnol/sql/default.mspx

Calling scripts doesn't seem to be a high I/O solution;

Assuming the scripts are stored on the computer from where the application runs...

Have a look at

http://www.sqlservercentral.com/articles/articleList.asp?categoryid=102

1. Have a proper design (very very important)

2. Try to avoid holding locks (not retrieving all rows, waiting for user input in the midst of...

There are no errors in the SQL Server log?

Is Server1 sql server still reachable when it can't communicate with the other sql server?

Fully patched (windows + sql server)?

Ram tested?

You will need the /PAE switch for >4GB

see http://support.microsoft.com/?id=283037