Ward Pond's SQL Server blog

Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)

Paul Randal Explains a Performance Bug

Paul Randal Explains a Performance Bug

  • Comments 3
  • Likes

Paul Randal has another must-read post regarding a performance bug which surfaces in earlier versions of SQL Server 2005 and SQL Server 2008 when NOLOCK scans are executed against tables with off-row LOB data.  Both the causal scenario and the nature of the fix are clearly discussed.

Get your geek beanies a-twirlin’ and check out Paul’s post.

-wp


this copyrighted material was originally posted at http://blogs.technet.com/wardpond. 

the author and his employer are pleased to provide this content for you at that site, and via rss, free of charge and without advertising.

the author welcomes and appreciates links to and citations of his work.  however, if you are viewing the full text of this article at any other website, be aware that its author does not endorse and is not compensated by any advertising or access fees you may be subjected to outside the original web and rss sites.

Comments
  • I'm amazed that such a bug could exist for so long!

  • I'm also amazed to see this bug.

  • I am also amazed about this bug. I never worked with LOB though.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment