The TempDB gets rebuilt each time you restart the SQL Server Service so this seems strange that a global temp tables remains.  How exactly is this impacting your backups?

I'm not sure I totaly agree with you guys on processes not being able to block themselves.  A process can show up as blocking iteself when there is network or...

Sree, you've gotten some great advice here so far.  I only have one thing to add.  If you've been tasked with looking into performance tuning an application, a good first...

I'm not sure.  Books on line does not say this.  Microsoft's MSDN page says it is new to SP3: http://msdn2.microsoft.com/en-us/library/aa214020(SQL.80).aspx

It is an executable that gets installed with SQL Server.  It will be in your SQL Server installation directory's Binn folder.  Just run SQLDiag.exe.  It takes just a minute or...

I would also recommend that you run SQLDiag at the time of freeze up.  This will help determine blocking/locking issues and wait types as well as much other useful info.

I don't know if you can read the column names in via ActiveX, but there may be a way that I am not aware of.  What about using the data...

You mean if the duplicates are not limited to the 5 columns and instead we have to check all 60 columns?  In that case, you must scale out the GROUP...

There may be a better way, but here's what I would start with. 

1. Create 2 staging tables, one for the Quantity data and one for the Price data.

2. Import the...

You say that 5 of the columns define the uniqueness.  I assume then since you have a duplicate row that there is not a constraint of any kind here to...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

According to Microsoft, you should not be concerned with fragmentation levels of indexes...

Well, if you look in BOL, error 701 says:

There is insufficient system memory to run this query.

Can you tell us a bit more about your environment (Windows OS, SQL Server...

So does the job actually fail or does it just appear hung?  If it does fail, what is the failure message?  If it just appears hung, have you looked at...

I don't think this is a protocol issue.  Especially if you've had a significant increase in your storage requirements.  Timeouts occur because a process is taking too long (big duh,...

I think we need a bit more info here.  Can you post your table DDL, sample data, and an example of what you want to have happen.  What determines which...