T-SQL Anti-Patterns: Linked Server Joins

Yesterday's anti-pattern, non-SARGable ORs in joins, was all about writing code which the SQL Server database engine can optimize.  Today's anti-pattern is in that vein, but this time we're looking at cross-server queries. Linked servers are a powerful feature within SQL Server, and I don't want to throw them out entirely.  What I do want…

Advertisement