Tag Info

New answers tagged


Hopefully with that size you are on Enterprise edition? If not, good luck :) (just kidding see bottom of answer) If you are on Enterprise, I would suggest looking into partitioning. This has saved my butt a time or two when dealing with this same kind of scenario. Create your partitions on the date field and you will have to best determine how big you want ...


Depends a bit on the data access patterns. I assume it's written sequentially. Is that true? How about reads? Sequential or random? If everything is sequential and you've got a robust I/O pipe you'll be fine. If it's random or you have a poor I/O setup you'll run into problems without archiving data off. Mind, you've given no hardware detail so I'm making ...

Top 50 recent answers are included