ChrisM@Work (9/27/2012)
Evil Kraig F (9/26/2012)
...OPENQUERY is another way I'd forgotten to enforce this, though it's not one I'd typically prefer to use... but I forget why I came to that decision.....
Craig, interesting - putting the filter into the OPENQUERY would potentially reduce the number of rows returned "down the wire" - what disadvantage could there be?
Personally the open query is the method I prefer. Makes it very clear and certain which portions of the query will be run remote and which local.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass