Has anyone found a solution for this? I'm using Server 2003 and SQL Server 2005 with same prob. The SynAttackProtect=0 did not help either. I'm seeing nothing...

The following works too:

convert(char(8),tablename.datetimefield,112) between '20030801' and '20030831'

You are not alone...it is running slow for me as well. I just discovered this forum last week and have found it to be very helpful so far.

Thanks for the suggestion. I tried the new update on a small range (using a where clause) of data to get execution times so I can estimate how long...

The query needs to complete. Assuming it is hosed up now how can I go about estimating an appropriate amount of time for this query? This is what...