RE: Solving NOLOCK SQL Power BI issues with Sample Code for STEEMSQL

[ace108]

One more thing, I see you use a condition of

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.

I suspect MS SQL should be the same. author in ('somebody') author = 'somebody'

Comments

[paulag]

Thank you!

[ace108]

you're welcome :-)

[yassine1234]

doesnt it force

[ace108]

Don't know for sure but if you have the answer, please do update.