Listing 2: Script That Deletes Oldest 5000 Rows with ModifiedDate Earlier than 2003 from 
BigTable

SET NOCOUNT ON; USE tempdb;

DECLARE @BatchSize AS INT;
SET @BatchSize = 5000;

WITH Batch
AS
(
  SELECT TOP (@BatchSize) * FROM BigTable
  WHERE ModifiedDate < '20030101'
  ORDER BY ModifiedDate
)
DELETE FROM Batch;