SinisterPenguin (10/27/2009)
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.
I guess I must have somehow misinterpreted this statement from you then: "You won't get any performance improvements just by partitioning."
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service