Thanks. I searched online articles. But for 64bit it is not mentioned.

Thanks for the suggestions. I understand that this has to be done through linked servers (sp_addlinkedsrvlogin) . But I'm unable to get exact example for...

Thank you Roy.

Roy

Thanks for your reply. Can you please give me an example?

Rgds

Mohan Kumar VS

Thanks a lot.

Thank you very much.

I executed the script twice. There are some indexes still with 40-55% fragmentation and page_count ranging from 9-151.

Eg.

tbl1 Frag 38.88 PageCount18

tbl2 Frag 11.11PageCount9

tbl3 Frag 7.01 PageCount57

tbl4 Frag 5.30PageCount151

IndexID...

Thanks Jack & Paul.

I tried the script. But it is not completely eliminating the fragmentation. Upto 90% of fragmentation is removed.

Thanks again.

Regards

Mohan Kumar VS

Thanks for your response. But I tried after selecting the required database.

Anyways, I will try the script which you have mentioned also & inform you.

Rgds

Mohan Kumar...

Congrats Josef !!

I read the interview. It also tells us about your good qualities.

Rgds

Mohan Kumar VS

Congratulations Josef! I read the interview posted. It tells us about your good qualities also.

Congratulations Josef! I read the interview posted. It tells us about your good qualities also.

I thank all of you for your help. I will try & let you know.

Rgds

Mohan Kumar VS

Hi

Check this link: http://www.mssqltips.com/tip.asp?tip=1240

Hope this will be helpful.

Regards

Mohan Kumar VS