[dba-SQLServer] [AccessD] Apples to Oranges

jwcolby jwcolby at colbyconsulting.com
Mon Oct 4 17:05:13 CDT 2010


One pass of the query that updates the ' ' (space) to null value takes about 5 minutes on the SSD, 
whereas it takes about 30 minutes minutes on rotating media.

I am not pursuing actually doing this on the SSD over nagging concerns about hot spot wear.

However a actually need to do this for about 540 fields.  At 1/2 hour / field... this will be 
running for the next month.

John W. Colby
www.ColbyConsulting.com

On 10/4/2010 5:36 PM, jwcolby wrote:
> With an index, both databases took 2 seconds to return the results.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 10/4/2010 5:16 PM, jwcolby wrote:
>> I On the new server, have the same database on my SSD (two drive) raid 0 and a rotating media (2
>> drive) Raid 0.
>>
>> There is a clustered index on the PK as the index key.
>> There is no index on the FieldX, forcing a field scan.
>>
>> I did a simple count PK Group By FieldX on both database files.
>>
>> The SSD returned the counts in 1:31
>> The rotating media returned the counts in 8:58
>>



More information about the dba-SQLServer mailing list