Tag Info

New answers tagged

2

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 ...


0

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