thank you,

but my question is still not answered.

yours sincerly.

yes i have cheked all possible things,

and finally came to conclusion that making one flat table would be good idea.

so all my queries are related to this flat table. and...

I am trying to get speed by making one table out of many table joins from queries.

and collocation is stroger form of alignment of partitioning (mssql 2005)

note:(I tried to change...