HI THanks for your reply.

May i have more details , if possible (from other users).

Just to get equipped more.

H.

Thanks a lot to all for their valuable comments.

H.

thanks a million.

Now its more clear.

I think i need to study more about filegroups / disks , in order to understand better sql database design.

thanks

H.

thanks.It was clear.

SO lets take an example , where our database will be 2TB very soon and there are some tables which will be very big.how we should divide or...

HI heavymind1 and Ratheesh,

thanks for your comments.

Well agreed on comments but since i am not a programmer , so i must know as a DBA , either how to do...