SQL Commands

Delete notifications older than 1 year

DELETE FROM Production_Coach.dbo.Notifications
WHERE Date < DATEADD(YEAR, -1, GETDATE());