DELETE FROM [dbo].[logs] WHERE date < DATEADD(DAY, -30, GETDATE())