Lookup Partitioned Views" and you will see.You are correct about the initial setup being a bit complex especially if you have an IDENTITY column in the table, but it is worth the effort even on a 350GB database especially when you consider things such as backup and restore times.