Hi Jeff

Yes. There are 16 seperate physical drives on which the files are distributed. And the reason for simple recovery model is that the transaction logs are really huge and...

Sorry for the late response. I had asked for a discussion with my DBA on why they are doing SIMPLE recovery instead of Full recovery..

But we have split our...

Thanks Jason.

Your suggestion is one of the main benefit that we want to achieve. The ability to leave tables that we do not do development in the next few months...

Thanks Gila for the link. I remember reading that post sometime back and Thanks for helping me refresh my memory on that.

I had some inputs from my DBA. We are...

Partition maintenance we will not be doing frequently and definitely would require a maintenance window as you suggest.

Purpose for partitioning:

1. Inspite that some of the tables are huge(billions of rows)...

Thanks for the quick response Grant.

I was thinking in those lines till I thought about splitting/merging these ranges. Say for instance I create partition ranges of 10 million intervals...