Lynn Pettis (7/5/2011)
Paul, realize this is an old thread, but I have a question. Would the use of the ALTER TABLE ... SWITCH TO ... require that the use of the Enterprise Editon of SQL Server?
Hi Lynn,
This is the number one question I get asked about this - and the answer is most definitely 'no'.
All tables are partitioned (most just happen to have one partition!) and ALTER TABLE...SWITCH is available in all editions of SQL Server. Full table partitioning (with schemes and functions and such) is indeed Enterprise-equivalent-only.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi