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 !