Cumulative max-length for index on SQL servers... please help

Look for "maximum capacity specifications" in Books Online, this info
and more can be found there.
almurph@.altavista.com wrote:
> Folks,
> What is the cumulative max-length of columns in both a clustered
> and/or nonclustered index for:
> a. SQL Server 2000
> b. SQL Server 2005
>
> Any comments much, much appreciated...
> Thank you,
> Al.Folks,
What is the cumulative max-length of columns in both a clustered
and/or nonclustered index for:
a. SQL Server 2000
b. SQL Server 2005
Any comments much, much appreciated...
Thank you,
Al.|||Look for "maximum capacity specifications" in Books Online, this info
and more can be found there.
almurph@.altavista.com wrote:
> Folks,
> What is the cumulative max-length of columns in both a clustered
> and/or nonclustered index for:
> a. SQL Server 2000
> b. SQL Server 2005
>
> Any comments much, much appreciated...
> Thank you,
> Al.|||Tracy McKibben wrote:
[vbcol=seagreen]
> Look for "maximum capacity specifications" in Books Online, this info
> and more can be found there.
>
> almurph@.altavista.com wrote:
Number of columns should not be more than 16 and cumulative length
should not be more than 900. But you can use included column opation in
SQL Server 2005 to add more columns.
More help you can find in Create index statement in BOL and Maximum
Capacity Specifications for SQL Server 2005
Regards
Amish Shah|||Tracy McKibben wrote:
[vbcol=seagreen]
> Look for "maximum capacity specifications" in Books Online, this info
> and more can be found there.
>
> almurph@.altavista.com wrote:
Number of columns should not be more than 16 and cumulative length
should not be more than 900. But you can use included column opation in
SQL Server 2005 to add more columns.
More help you can find in Create index statement in BOL and Maximum
Capacity Specifications for SQL Server 2005
Regards
Amish Shah