Start reading SQL Server Concurrency on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books – even without a Kindle device-with the FREE Kindle app for smartphones and tablets.
SQL Server Concurrency: Locking, Blocking, and Row Versioning
 
 

SQL Server Concurrency: Locking, Blocking, and Row Versioning [Kindle Edition]

Kalen Delaney

Print List Price: £19.99
Kindle Price: £6.79 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.20 (66%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £6.79  
Paperback £19.99  
Amazon.co.uk Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.


Product Description

Product Description

Multiple processes often access the same data at the same time, so SQL Server has to make one process wait, sacrificing concurrency and performance.

This book explores how SQL Server uses locks to avoid concurrency problems, and advice on the to control locking with hints and bound connections. It also walks you through how row versioning works, and how to troubleshoot excessive blocking and deadlocking.

Product details

  • Format: Kindle Edition
  • File Size: 1186 KB
  • Print Length: 202 pages
  • Publisher: Red Gate Books (23 May 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00CZ1BVGY
  • Text-to-Speech: Enabled
  • X-Ray:
  • Amazon Bestsellers Rank: #438,866 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


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: 3.0 out of 5 stars  2 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Clear, concise and indispensable 6 May 2013
By Mladen Andrijasevic - Published on Amazon.com
Format:Paperback|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
1.0 out of 5 stars No content 18 Jan 2014
By David Scheffer - Published on Amazon.com
Format:Paperback|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

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


ARRAY(0xaeb0cd44)