Need you advice.. I have database which has 3 tables with ntext columns in each and couple of smaller tables. Each table will have around 10,000 rows added each day during normal hours of operation and nightly batch job will purge around same count of rows which have say x number of days old. The ntext column will have variable lenght of text characters(no images). The small tables are will not be purged as above transaction tables.
So, What should be done with initial layout of the table and filesytem so performance will not degrade as data is loaded/purged everyday?
What possible and better option is available in SQL Server 7.0?