10000 rows at a time.
DECLARE @i INT SET @i = 1
SET ROWCOUNT 10000
WHILE @i <> 0 BEGIN DELETE FROM dbo.table
SELECT @i = @@ROWCOUNT END
SET ROWCOUNT 0
-f.