WHILE @@ROWCOUNT <> 0 BEGIN DELETE TOP (1000000) FROM [database].[schema].[table] WHERE [Col1] = 'abc' DBCC SHRINKDATABASE(N'_APPL' ) END