Home Forums SQL Server 2005 Administering Partition Existing Table with Data RE: Partition Existing Table with Data

  • October 27, 2009 at 5:21 am

    #1071122

    TheSQLGuru (10/27/2009)

    1) the first poster is incorrect. you CAN get performance increases from partitioning without multiple filegroups - sometimes vast improvements even. This would come from partition elimination during query execution.

    I didn't say you CAN'T get performance gains I was simply pointing out that table partitioning is designed primarily as Management technology rather than a performance enhancing technology.