Hi, i did a quick report of the all the table size via the report tool and discovered that some of the tables has millions of row that i don’t need, as shown in the image
Is there a job that actually deletes old data or if there is a way i can intervene manually via sp and delete data older than 3 months?
I know from the documentation that i can compress theses tables but that the last resort and eventually i will do it.
Thanks and you all have a good day!