I've done this but not the way you want. It's super simple, though. Create another database, move your large table to that, and create a synonym in the original database named the same as the original table. You won't need to change a lick of code anywhere. The only problem is that you can't do DRI across databases so that's a consideration. You can, however, replace the likes of FKs with Instead of Triggers, which can be made to be pretty efficient if they are needed.