TheSQLGuru (10/27/2009)
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."
Don't get me wrong I'm happy to be corrected - but if you just partition a table & don't make any other changes, i.e. all partitions are still on the same Filegroup how will performance improve?