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: 636

Filed under:
|
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

Related posts about locks