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 my question was related to having more cols in

one table or to have two tables with less cols is better or not.

selecting 50 cols out of 150 cols from a table is good or breaking the table into two and having 50 cols in one table and rest in other . and then selecting 50 cols from one table with joining.

i just want general behaviour of sql server in above situation , so that i can decide breaking it or not

with out making index, because i know that index will speed up and that option will be present even after breaking the

table. so that my queries can execute in zero second in database at least.

yours sincerly.