Home Forums SQL Server 2008 SQL Server 2008 - General speed up deleting million of records from a table with one filter RE: speed up deleting million of records from a table with one filter
peterdru401
Mr or Mrs. 500
Points: 535
More actions
November 8, 2012 at 2:02 am
#1557050
Simplest solution is to use a WITH. e.g.
WITH results ( <select> ) DELETE FROM results –