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
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
]]>