[dba-SQLServer] [AccessD] Apples to Oranges

Stuart,

Your gut feeling is correct.  We created a dynamic sql statement and updated 100 columns 
simultaneously using your method and it ran in 33 minutes.  I am now going for broke and doing the 
rest of the columns.  We have updated 160 total so far so the next pass will try to do all the 
remaining columns in one blast.

Thanks for recommending this method, you have saved my poor disk drives weeks of punishment.

John W. Colby
www.ColbyConsulting.com

On 10/5/2010 8:14 AM, Stuart McLachlan wrote:
> Don't know, but my gut feeling is that a single pass has got to be way more efficient that 540
> of them.
>
> Why not try it on a subset of the records and see how long it takes.
>
>