SQL Server NOLOCK / ROWLOCK Directives To Improve Performance

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

For Cut-and-Paste