3 responses

  1. Paul McLoughlin
    November 16, 2012

    Thanks for pointing out this improvement. Unfortunately there still appear to be issues with row estimates when views are used over linked servers. If we create a view on the remote side of the form "create view dbo.MyView with schemabinding as select charge_no, member_no from dbo.charge" and use that in the query rather than the remote table we get row estimates of 10,000 rows regardless of the credentials used on the linked server.

    Unfortunately for me this still leaves linked servers a poor second class citizen and a source of many performance issues.

  2. joe
    November 18, 2012

    Thanks Paul. Did you file a Connect item for this? Sounds worthy of it.

  3. Paul McLoughlin
    December 11, 2012

    I’ve raised a connect item (https://connect.microsoft.com/SQLServer/feedback/details/773286) so I’ll wait to see what Microsoft come back with

Back to top
mobile desktop