"Jéjé" <willgart@BBBhotmailAAA.com> wrote in message
news:OOvqXIN%23FHA.2472@TK2MSFTNGP12.phx.gbl...
> have you try to partition your table horizontally?
> create 1 table with the most requested columns, and a second table with
> your "slow" varchar columns.
>
> The row size in the first table will be smaller, so you'll have more rows
> by page.
>
> but, because you ask under the data warehouse newsgroup, remember that
> reducing the number of joins improve the response time.
>

This is almost always a bad idea, and in SQL Server 2005 (with indexes with
included columns) the "almost" goes away.

You can do better by adding commonly used columns to the clustered index
(still not always a good idea, but better than "horizontal partitioning".

David