Hyperthreading won't affect the tempdb, growth factor or tran log size. However it may be the problem for this "Write requests are refused, whereas read requests are processed, and any...

One more thing. If you have hyperthreading turned on, turn it off.

Are you sure you're not running out of log space? If you have a 1.6tb database I don't see how the 80gig log will be large enough! Maybe I'm missing...

Francisco,

You might think about the possibility of turning the sproc into a udf. In this way you would then simply do the following.

INSERT INTO #Foo(...)

SELECT ... FROM dbo.f_YourNewUDF(...)

Add a log table that you put a record in when the process starts and another when the process finishes. Then simply query the log table using the NOLOCK hint....

Can you give us some ddl and a sample query to work with? Also if you separate it out to individual queries do they all run?

I don't think your VB code is correct on the last post. You would first have to create the command object and then execute it. At that time you should...

I don't think I would want to have my SQL Server calling winsock directly. If it were to error out more than likely you would end up downing the server

This is going to make your life miserable in the long run.

As Alzdba stated I would add an identity column to use as an alternate key for table and...

This is because you have "Smart Quotes" replacement turned on in Word. If you go to the "AutoCorrect" settings you can turn it off and you should no longer have...

If you are worried about the data becoming dirty I would use a transaction and set the isolation level as appropriate. In this way if the update were to fail...

I don't think it is the constraints that are causing the problem here.  Here is what I would try.

Create a nonclustered index on the CycleID and ExtractTypeId fields to use...

You could do something like

WHERE distance <= ISNULL(@MaxDistance, distance)

OK. Lets try removing the SQL Maint all together and creating a job manually to see if we can find out what is happening.

Try creating a backup device using the remote...

In this last DDL I see a few places you could speed this up. First since you moved the data into the temp table to do the update. Make sure...