mah_j (11/21/2012)
Thank you both for your comments.Does it have any effect,If i implement partitioning only on one drive ?
I will read more,and also focus on partitioning.
your question depicts that you havent read the link 🙂 . actually partitioninig gives you edge when u distribute/segregate the data on diferent disk to divide the IO load . see the link for more details
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)