[thelist] SQL Server, Updates and Locking Hints
A Maynes
andrew at milords.com
Wed Jul 6 04:32:13 CDT 2005
I am looking for a MSSQL & MySQL guru in the UK anyone interested?
Andrew
> -----Original Message-----
> From: Paul Cowan [mailto:evolt at funkwit.com]
> Sent: 05 July 2005 21:33
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] SQL Server, Updates and Locking Hints
>
>
>
>
> On 5/07/2005 3:04 PM +0100 Chris Hayes wrote:
> > I'm guessing here, but rather than not recommend a book I think you
> > typo'd this, I spent a while scanning the end of the
> sentence for the
> > word "enough".
>
> Errr... yes. I can't recommend it ENOUGH.
>
> Thanks Chris.
>
> <tip type="SQL" author="Paul Cowan">
> If you often have to update multiple tables in one
> transaction, come up
> with a consistent order in which to do it -- "always update
> the Authors
> table first, THEN the Books table, THEN ... " etc. If you
> stick with a
> consistent order, you'll greatly reduce the chance that any
> contention
> problems will lead to deadlocks.
> </tip>
> --
>
> * * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list