It's not exactly what I was searching for, but maybe I'll comeup with it later :

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

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

- http://support.microsoft.com/kb/q193095/

I was aware of the concept you had in mind , but I don't think this is implemented in sql2005.

I think Windows WLM...

This is the same debatecontext like for NULLs.

OK, DRI is a pain in the but for developers, but it guarantees some data related...

in addition to PW 's reply ...

is the create table for the temptb also within this transaction ?

I've read about this situation...

how recent are your statistics ?

run sp_updatestats and dbcc updateusage ('yourdb') with count_rows.

This may interfere with ongoing operations !

Then check your...

just a wilde shot ...

The hostname is determinde by data from the connection string.

What's the application name that's shown ?

In case of excell...

It might make sence to run sp_updatestats and dbcc updateusage(0) with count_rows manualy. This may interfere with ongoing operations !

Then try your procedure again

If your applications connect using the IP-address there will be no problem.

just be sure to follow this: http://www.databasejournal.com/scripts/article.php/1496451

and...

just my 2ct.

in addition to PW's and Strommy 's replies :

Your cluster-instance must have the new...

take a look at http://www.sqlservercentral.com/scripts/contributions/592.asp

imo if you allocate a drive letter (net use z) , you should also unallocate it (net use z /delete).

Unless offcourse this is an action that would be performed very often.

Then...

who needs a drive when you have UNC ?

\\myserver\myshare 

"Change your recovery option to Simple this will prevent the log from capturing all the data and filling up" ....

Nop.

It will depend on your...

Log files will only shrink up to the last active log chunk.

so it may be needed to run the shrink-file x-times.

-- Shrink_TrxLog.SQL

--INF:...

Maybe you'll find some script a the SSC-scripts section.

Here's one I install by default for dev-support :

-- it uses the msdb-tables and will...