I have a SQL Server table which I use to store events.
I only want the table to contain the 1000 most recently added rows, when row 1001 is inserted, row 1 should be deleted.
I have both a DateCreatedUTC column and an autonumber column.... I could write a query to execute a delete and trigger it on
INSERT but I don't know that this is the most appropriate solution.