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

Never seen sql server dropping databases on his own.

Sure there isn't an (backup)application/job/user doing this?

Perhaps you can set up profiler to listen for sp_detachdb commands

You mean the scripts are stored on the server and are called using xp_cmdshell? Or that they are send across the network as sql-statements?

1)Advantages using stored procedures:

Reduces roundtrips (network latency)

Managebility,resusability...

SELECT convert(datetime,'20050910') as myDate

select convert(varchar(20),convert(datetime,'20050910'),103) as myVarCharDate

Should do it.

select avg(DurationSummed.duration)

from

(select sum(duration) duration

from cutlog group by datepart(dy,date))

) as DurationSummed

?

make an union?

select columnA as MyColumn

union all

select columnB as MyColumn

union all

select columnC as MyColumn

In order to update on a linked server there should be a primary key on the table to function as recordidentifier.

Delimiting all identifiers is an excellent approach.

I think by lazyness and readability we decided to use a naming convention prohibiting the use of problem object names ( like spaces in...