mah_j (12/10/2012)
also i think the page split would be decreased in the partition that i want to select from it.
NO , partitoning is not related with page spliting and
for partitiioning see this http://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)