One more thing, I see you use a condition of
author in ('somebody')
That's useful if you want to go with more than one author. In Oracle SQL, when you want only one, the performance is better if you do.
author = 'somebody'
I suspect MS SQL should be the same.
RE: Solving NOLOCK SQL Power BI issues with Sample Code for STEEMSQL