[dba-SQLServer] Indexes not all listed

Hi my name is John and SQL Server 2008 was my idea (run and duck)

Sent from my mobile

On Dec 15, 2009, at 6:56 PM, jwcolby <jwcolby at colbyconsulting.com>  
wrote:

> Well, I just discovered my reason to update to SQL Server 2008.
>
> 2005 has a maximum number of non-clustered indexes per table of  
> 250.  SQL Server 2008 has a maximum
> of 999.  I have 584 fields that I need to create indexes on.
>
> Time to do an install...
>
> ;)
>
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>