[dba-SQLServer] Indexes not all listed

jwcolby jwcolby at colbyconsulting.com
Tue Dec 15 20:56:08 CST 2009


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



More information about the dba-SQLServer mailing list