[dba-SQLServer] SPAM-LOW: Re: Indexes not all listed

jwcolby jwcolby at colbyconsulting.com
Thu Dec 17 08:21:27 CST 2009


LOL.

uuhhhh yup.  I kin do this har database thing.

John W. Colby
www.ColbyConsulting.com


Francisco Tapia wrote:
> 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
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



More information about the dba-SQLServer mailing list