Table Partitioning Is Awesome for Data Base Administrators

This also means that if you use enterprise edition for your production sequal server, but your disaster recovery plan is to restore the data base off to a standard edition server, it's knot king. Table partitioning can be done without a lot of developer work. You may need to rewrite the t seple or really carefully tone your indexes to get queries to perform as well as they can against a non partition table.