Abstract
In the last two chapters, I covered DataModification Language and provided recipes for SELECT, INSERT, UPDATE, and DELETE statements. Beforemoving on to Data Definition Language (creating/altering/dropping tables, indexes, views, andmore), in this chapter I’ll review recipes for handling transactions, lockmonitoring, blocking, and deadlocking. I’ll review the new SQL Server 2008 table option that allows you to disable lock escalation or enable it for a partitioned table. I’ll demonstrate the snapshot isolation level, as well as DynamicManagement Views that are used tomonitor and troubleshoot blocking and locking.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Joseph Sack
About this chapter
Cite this chapter
(2008). Transactions, Locking, Blocking, and Deadlocking. In: SQL Server 2008 Transact-SQL Recipes. Apress. https://doi.org/10.1007/978-1-4302-0625-5_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0625-5_3
Publisher Name: Apress
Print ISBN: 978-1-59059-980-8
Online ISBN: 978-1-4302-0625-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books