Thanks for the replies guys, i managed to do a tabanalys from the backup of our database and its shocking, our most commonly used tables have a scatter factor of 5-7 so i think im going to dump and load them into thier own storage areas.
problem i had on our test database though is when i...