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 3:41 am

    #929573

    abhishek.sahoo (1/20/2009)

    We have table reside in a linked server having more than 15 million data. Please provide me a T -SQL which can retrieve the number of rows as fast as possible (the query should fetch count from a linked server).

    select Count(*) From count(. )

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