I have said it many times before and will say it again. Table Partitioning in SQL Server is a very complex subsystem with lots of requirements, conditions, gotchas, etc. You have very little chance of success if you just read a few forum/blog posts and Books Online and slap it into your system - even if you have extensive Oracle experience. I can't tell you the number of clients and forum people that have gotten themselves into a mess, or at best increased complexity in their system for no benefit, from doing partitioning on their own. And most don't actually NEED partitioning in the first place. Please consider getting a professional on board to help you understand what SQL Server Partitioning is and is not, review your requirements, and move you forward in the best direction successfully.