Posted by Dan Guzman on 02/27/06 14:13

If your database is running ALLOW_SNAPSHOT_ISOLATION ON, you might try
testing with it turned off to see how that affects performance. Like Erland
said, something is wrong with performance that slow.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"sql server" <nnelson@cmscms.com> wrote in message
news:1141018808.405308.30200@t39g2000cwt.googlegroups.com...
> 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.
>

[Back to original message]