delete from ??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

delete from ???

Hi i have from with Delete from statement. In particular table i have 2000 records. Now when i am issuing delete from statement in Query Analyzer to delete particular record from table, on server it is taking 36-50 seconds to delete. And from node it is taking almost 1 1/2 minutes. Is their any other method available to speed up Delete from statement.
I am using Sql server 2000.
Immediate reply will be appreciated. Tushar

Please don’t post the same question multiple times!
Though it’s urgent it doesn’t yield you anything. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterstuetze PASS Deutschland e.V.