Viewing 4 posts - 1 through 4 (of 4 total)
Thanks Jacob for your valuable suggestion. Definitely I will try to implement it and let you know if I face any issue. Could you please tell me any other...
January 21, 2009 at 12:25 am
Its working and the result is coming with in seconds. Thanks a lot Ramesh! Thanks All!!
January 20, 2009 at 4:37 am
I am not sure whether we can use sys index to retrieve data from a linked server. The T-SQL you have provided works fine if the table is in same...
January 20, 2009 at 4:11 am
No, I expect something that can retrieve data faster. Your one will take a longer time to execute if the record count is more than 15 million.
January 20, 2009 at 3:49 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy