automatically enforcing max database list distance dropping aged rows

i have an seer list contains eventuality record messages an application. don't wish list grow out control eat adult too many space, we'd set top array rows enclose large array million.

so we'd tell seer list grows too large, should mislay oldest rows space new rows.

is there any proceed this? i suspect trigger origination inserts stored procedure, nonetheless there anything simpler?

edit: integrate answers have suggested solutions secure partitions. now assign table, nonetheless have ability necessary. however, looking matter, seems even assign table, we'd still need kind scheduled office dump aged partitions, etc. we've solid abandon partitions preference scheduled office check quarrel count mislay aged rows required once per day.

thanks help, everyone.