Cetin,

>SQL server views might be faster (especially if using partioning)...

Why would you expect views to be faster than querying the tables and using "AS" clauses on field lists in the Select? Why would partitioning make a difference in view vs table?

>Also another option is to use functions (like views but you can pass parameters) which are even faster IMHO.

Got a simple example?