deleting data from a MSSQL table in chunks

Often I've found it more reliable to break up data destruction into chunks

CTE ( Common Table Expressions) makes it easy  and quick to delete the top x number of records from a table


;WITH CTE AS
(
SELECT TOP 10000000 * FROM [dbo].[TargetTable]
)
DELETE FROM CTE 


If you want to get rid of all data in the table, there is always

TRUNCATE TABLE [dbo].[TargetTable]