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:09 am

    #929588

    steveb (1/20/2009)

    This method should be faster

    SELECT rows FROM sysindexes

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

    Here the local sql server's object id will need to apply. but if you will run the same command on the linked server. again the speed isssue will arise especially for such large data

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com