SQL Server Concurrency: Locking, Blocking and Row Versioning by Kalen Delaney
Requirements:.PDF reader , 3.3 mb
Overview: In general, database systems can take two approaches to managing concurrent data access: pessimistic or optimistic. Prior to SQL Server 2005, pessimistic concurrency was the only available model. SQL Server 2005 and later versions support both models, but pessimistic concurrency is still the default and is the recommended model until you have thoroughly tested optimistic concurrency and verified that the extra costs are worthwhile.
This book will examine the details of both concurrency models and explain what factors we must consider when comparing the relative costs on our systems. We’ll also discuss concurrency concepts, such as transactions and isolation levels, that we must understand, no matter which concurrency model we’re using.
Genre: Tech & Devices – Database
Download Instructions
http://destyy.com/wBn7Kz
mirror:
http://destyy.com/wBn7KR
http://destyy.com/wBn7KO