Posted by sql server on 02/27/06 07:40

Thanks again for your reply. I never did solve the puzzle here.
Instead I ran three cursors at 10,000 a pop to delete the rows. It
still took a number of hours to complete. To me it's still baffling.
I have the same database in SQL 2000 and never had that problem over
there.

Oh well. I'm able to move forward today anyway.

• Next in forum: Announcing Yellowfin BI reporting Version 2.4 release now available.
• Prev in forum: Re: how do we tune a large sql query
• Thread view: Re: DELETE FROM - Somethings not right

[Reply to this message]