Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT * FROM Posts p WITH (nolock) JOIN Users u WITH (nolock) ON p.ParentId = u.Id WHERE u.DisplayName like '%pugsley%'