You may want to look at the OPENQUERY syntax, which may help to resolve performa... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

joeriel on March 7, 2016 | parent | context | favorite | on: Announcing SQL Server on Linux

You may want to look at the OPENQUERY syntax, which may help to resolve performance problems related to remote joins.

Edit: Useful if both tables in join are on remote (linked) server

merpnderp on March 7, 2016 [–]

I solved it by breaking it into two queries in my sproc. Suboptimal, but also done :)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact