I think you should consider using partition view with tables being in multiple databases. It will also reduce your backup time and rebuild indexes, if data is not changing for...