index key limitation

I am wondering if there is a limit on key size as far as relates to
performance ?
The limit would probably be the same as rowsize / sorting (~8k), but
generally you want to keep your keys as small as possible. You might want
to read
http://www.aspfaq.com/2504
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Aron E. Tekulsky" <atekulsky@.iie.org> wrote in message
news:uXvQXWcQEHA.3732@.TK2MSFTNGP11.phx.gbl...
> I am wondering if there is a limit on key size as far as relates to
> performance ?
>
|||User specified index key size limitation is 900 bytes for both clustered and
non-clustsred index.
Gang He
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aron E. Tekulsky" <atekulsky@.iie.org> wrote in message
news:uXvQXWcQEHA.3732@.TK2MSFTNGP11.phx.gbl...
> I am wondering if there is a limit on key size as far as relates to
> performance ?
>