<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	SQL Server NOLOCK / ROWLOCK Directives To Improve Performance
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:477.view
	
	Date Posted:
	Jan 16, 2007 at 9:34 AM
	
---- --------------------------------------------------------------------------------------- --->


SELECT
	b.id,
	b.name,
	( t.id ) AS tag_id,
	( t.name ) AS tag_name
FROM
	blog_entry b
INNER JOIN
	blog_entry_tag_jn btjn (NOLOCK)
ON
	b.id = btjn.blog_entry_id
INNER JOIN
	tag t (NOLOCK)
ON
	btjn.tag_id = t.id