Hi David,
1. I've already changed the Autogrowth of the following files
Data File (Autogrowth = 10% Unrestricted Growth) (Initial size = 35138 MB)
Log File (Autogrowth = 10% Restricted Growth) (Initial size = 10668 MB)
Have I set it up correctly?
2. The overhead involved with varchar() compared to char() is such that we've made a decision to not varchar()
any field that is char(10) or smaller.
We also did our table structure this way :)
3. How heavily inserted is your database? How heavily updated is it?
We have approximately 2000 to 3000 transactions per day. That would be about 6000 to 10000 records being inserted on our tables.
Updates do not happen very often. We only do updates for data correction, transaction adjustments and the like.
4. Is it possible or normal for the index file size to exceed the data file size, considering that only 50 percent of the fields have index?
Thanks in advance...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.