Clearing SIMSData (1000 lines per)

01/11/2024 9:33 am EST

DECLARE @Deleted_Rows INT;

SET @Deleted_Rows = 1;





WHILE (@Deleted_Rows > 0)

  BEGIN

   -- Delete some small number of rows at a time

    DELETE TOP (1000) SIMSData 

    where ComputerTime <  DATEADD(day,-30,GETDATE())

  SET @Deleted_Rows = @@ROWCOUNT;

END

Was this article helpful?