[thelist] SQL Server, Updates and Locking Hints

[A Maynes]

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 !