Q&A for people looking to bypass life's everyday problems with simple tricks
/* SELECT * --FROM Posts p WITH (nolock) --JOIN FROM Users u WITH (nolock) --ON p.ParentId = u.Id WHERE u.Id = 7816 */ SELECT * FROM PostHistory ph WITH (nolock) JOIN PostHistoryTypes pht WITH (nolock) ON ph.PostHistoryTypeId = pht.Id WHERE UserId = 7816