T-SQL Tuesday #006: LOB, row-overflow and locking behavior

Posted by Michael Zilberstein on SQL Blog See other posts from SQL Blog or by Michael Zilberstein
Published on Tue, 11 May 2010 03:51:32 GMT Indexed on 2010/05/11 3:56 UTC
Read the original article Hit count: 679

Filed under:

internals

|

locks

This post is my contribution to T-SQL Tuesday #006 , hosted this time by Michael Coles . Actually this post was born last Thursday when I attended Kalen Delaney's "Deep dive into SQL Server Internals" seminar in Tel-Aviv. I asked question, Kalen didn't have answer at hand, so during a break I created demo in order to check certain behavior. Demo goes later in this post but first small teaser. I have MyTable table with 10 rows. I take 2 rows that reside on different pages. In first session...(read more)

© SQL Blog or respective owner

Related posts about internals

SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting

as seen on SQL Authority - Search for 'SQL Authority'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task… >>> More
New Webcast - SQL Server Internals & Architecture

as seen on SQL Blog - Search for 'SQL Blog'
Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture (or view the archive). It's the most fun you'll ever have learning about the inner workings of a relational database - I promise!...(read more) >>> More
SQLAuthority Book Review Professional SQL Server 2008 Internals and Troubleshooting

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven WortLink to Amazon (Worldwide)Link to Flipkart (India)Brief Review: Having a book on internal and associating that with real life is almost an impossible task. The… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More

Related posts about locks

Inside the Concurrent Collections: ConcurrentDictionary

as seen on Simple Talk - Search for 'Simple Talk'
Using locks to implement a thread-safe collection is rather like using a sledgehammer - unsubtle, easy to understand, and tends to make any other tool redundant. Unlike the previous two collections I looked at, ConcurrentStack and ConcurrentQueue, ConcurrentDictionary uses locks quite heavily. However… >>> More
T-SQL Tuesday #006: LOB, row-overflow and locking behavior

as seen on SQL Blog - Search for 'SQL Blog'
This post is my contribution to T-SQL Tuesday #006 , hosted this time by Michael Coles . Actually this post was born last Thursday when I attended Kalen Delaney's "Deep dive into SQL Server Internals" seminar in Tel-Aviv. I asked question, Kalen didn't have answer at hand, so during a break… >>> More
Use Non-blocking Locks When Possible

as seen on Dr Dobbs - Search for 'Dr Dobbs'
Non-blocking system calls let competing threads return and useful work to be done System call - Thread - Programming - Business - Content Filtering >>> More
Reading and conditionally updating N rows, where N > 100,000 for DNA Sequence processing

as seen on Programmers - Search for 'Programmers'
I have a proof of concept application that uses Azure tables to associate DNA sequences to "something". Table 1 is the master table. It uniquely lists every DNA sequence. The PK is a load balanced hash of the RK. The RK is the unique encoded value of the DNA sequence. Additional tables are created… >>> More
Java - System design with distributed Queues and Locks

as seen on Programmers - Search for 'Programmers'
Looking for inputs to evaluate a design for a system (java) which would have a distributed queue serving several (but not too many) nodes. These nodes would process objects present in the distributed queue and on occasion require a distributed lock across the cluster on an arbitrary (distributed)… >>> More