RE: Is it possible to use nolock type of hint in query
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Peter McLarty'" <Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Aug 2006 09:27:01 -0400
SQL Server's default behavior is autocommit of each DML statement. Why? To
keep transactions short, because that's the only way to get reasonable
performance. The constant drumbeat of "keep transactions short" is a classic
tail-wagging-the-dog position.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: Peter McLarty [mailto:Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, August 15, 2006 3:00 AM
To: jkstill@xxxxxxxxx; norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx
Cc: paul.baumgartel@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
ineyman@xxxxxxxxxxxxxx
Subject: RE: Is it possible to use nolock type of hint in query
I will buy in with my two cents worth here from what I know of the use of nolock
Firstly it is part of a standard SQL Server approach to solving a performance
issue that can arise and to help SQL server to run multiuser, yes that right
multiuser
Due to the inadequacies of the sQL Server locking paradigm many applications
need to run transactions as read uncommmited. This is due to the way SQL server
locks when running a select. This delivers a problem in that if say posting is
running then the session of a user running a select on the same tables needs to
run select with a nolock or else the select will likely lock the table and
cause the posting process to fail
Which now begs the question is SQL Server a real database and how the hell do
you effectively scale it because there whole strategy seems to be built on a
number of fudges?
My 0.02c
Cheers
Peter McLarty
Technical Consultant
Service Delivery
Address:
67 High Street, Toowong QLD 4066
Phone:
+61733777542
Fax:
+61 7 3377 7301
Mobile:
+61410620391
Email:
Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx
<mailto:Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx>
Web:
www.TechnologyOneCorp.com <http://www.technologyonecorp.com>
EVOLVE 2007 - Connect. Learn. Empower.
Register today for the TechnologyOne Evolve 2007 User Conference
13 - 16 February 2007
Gold Coast Convention & Exhibition Centre, Queensland, Australia
www.TechnologyOneCorp.com/Evolve <http://www.technologyonecorp.com/Evolve>
.
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
