CODE EXAMPLE FOR SQL

sql server delete top 1000

;WITH CTE AS
(
SELECT TOP 1000 *
FROM [table]
ORDER BY column
)
DELETE FROM CTE