I agree it's not a hard threshold. Although in testing the threshold number is lower than I expected on the database server we are testing on (2GB RAM). Typically...

Thanks Steve. However the decision that Sql Server makes that it is more efficient is what causes the deadlock. Because if it decides at, say, 10 and those 10 are...

Point taken about the hints. I agree.

The pk in the example here is clustered. And it is a table with no other relationships or indexes.

You may have touched on two...

Thanks very much for your reply. It certainly gives me hope. And I will confess that I am an application developer rather than a DBA but have spent a...

Ok. Thanks for the link. When used in conjunction with the profiler it should help.

Thanks for your help.

Thanks for the reply. TCP was in the config but must have been disabled in the sqlserver startup by windows as there were no processes listening on 1433 according to...