Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Basu Hullur How to get the number of rows from a table reside in a linked server as fast as possible. RE: How to get the number of rows from a table reside in a linked server as fast as possible.

  • January 21, 2009 at 1:09 am

    #930151

    @abhishek-2:

    In that case you will have to use Ramesh's approach (if you want to use sysindexes). Make sure that the local server collation matches the remote server collation exactly, and specify Collation Compatible = True on your linker server definition.

    If you want an accurate result you're stuck with COUNT(), in which case collation doesn't matter.

    Regards,

    Jacob