• RRP: £19.99
  • You Save: £0.01
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
SQL Server Concurrency has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

SQL Server Concurrency Paperback – 11 Sep 2012

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback, 11 Sep 2012
"Please retry"
£10.32 £14.53
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£19.98 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

Frequently Bought Together

  • SQL Server Concurrency
  • +
  • Inside the SQL Server Query Optimizer
  • +
  • SQL Server Execution Plans
Total price: £51.95
Buy the selected items together

Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x93517a38) out of 5 stars 3 reviews
3 of 3 people found the following review helpful
HASH(0x9351f42c) out of 5 stars Clear, concise and indispensable 6 May 2013
By Mladen Andrijasevic - Published on Amazon.com
Verified Purchase
As all Kalen Delaney's other SQL Server Internals books, this one will become indispensable. Here all the information regarding SQL concurrency is in one place. Instead of reading her Hands-On SQL 2000 Troubleshooting: Locking and Blocking and Chapter 10 Transaction and Concurrency of SQL Server 2008 Internals - here is everything you wanted to know about concurrency in 184 pages.

The only sentence I would perhaps disagree with is on page 180: "SQL Server was designed and built, initially, to use pessimistic concurrency. Therefore we should consider using that model unless we can verify that optimistic concurrency will work better for our application." I think this may not encourage people enough to try RCSI . We switched to Read Committed Snapshot Isolation in 2007 for all our databases and it has worked wonderfully. We even set the is_read_committed_snapshot_on bit in the model database so that every new database gets created and runs in the RCSI isolation model.

Sometimes even one sentence in the book is worth reading the whole book cover to cover. In my case it was "Warning: The NOLOCK hint and RCSI . If application code invokes READ UNCOMMITTED isolation by using the NOLOCK hint ( or the equivalent READUNCOMMITTED hint), changing the database to RCSI will have no effect. The NOLOCK hint will override the database setting, and SQL will continue to read the uncommitted (dirty) data." I turns out we still had some 10 places where NOLOCK was still being used - leftovers from the days before RCSI was implemented.
0 of 1 people found the following review helpful
HASH(0x936dc4c8) out of 5 stars Insight into the inner workings of OUR SQL server 23 May 2014
By K. Wood - Published on Amazon.com
Verified Purchase
Kalen knows databases. When she speaks, (or writes) the smart DBA listens and this book is no exception.
Her examples and explanations are straightforward and easy for the DBA at any level to follow and understand.
Kalen makes the inner workings of SQL server easy to understand.
Reading this book will make any DBA sound like an expert.
0 of 2 people found the following review helpful
HASH(0x93e97bd0) out of 5 stars No content 18 Jan. 2014
By David Scheffer - Published on Amazon.com
Verified Purchase
There is no content beyond what one would get with a simple breeze through the MSDN library. Has the feel of resume fluffing.
Were these reviews helpful? Let us know

Look for similar items by category