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 20, 2009 at 4:01 am

    #929587

    This method should be faster

    SELECT rows FROM sysindexes

    WHERE id = OBJECT_ID('YourTableName') AND indid < 2