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.