... and PLEASE DON'T DOUBLE POST!!!!

http://www.sqlservercentral.com/Forums/Topic436572-338-1.aspx

The REAL question would be, WHY are you using a cursor for this? You should be able to do this in a setbased fashion...

have about 2,00,00,000 records in a table which are being queried.

More over I have 2 more tables of same specs mentioned above.

Queries are taking lot of time. usually...

Heh... I got the answer right but the real answer isn't one of those listed. The question is "What must he worry about when using the @@FETCH_STATUS function in...

Ok... another way to do it would be to export the data to tab delimited files on some common file share and use BCP or BULK INSERT to import the...

Dunno about most... I'd simply make linked servers and have a proc read the data in. Don't want to make a single view because if one of the servers...

Heh... a While loop... "Firehose" cursor would be just as good... take a look at the function I made in this thread... no explicit loop... no cursor... still basically hidden...

Hi Mark,

It's just the way this forum handles things when they repost an article... no updates were actually made.

Ion Freeman (12/28/2007)

---

The whole reason I don't write articles like this is because I don't want to do the heavy lifting around collecting metrics. So, I'd like to see that...

Heh... yeah... then there's that...

sorry Jeff I have to disagree, even if the clustered index is on an indentity column then the clustered index is actually the entire table, regardless of the index being...

Navision will find and rewrite performance challenged code?

Ok, since you brougt it up, I'll bite... what does Navision do?

Heh... agreed... but I'm not a moderator... usually, I'm just part of the problem 😛

That makes perfect sense...

Dinesh's fine solution will work for SSIS... I just don't like SSIS 😛