Hello Gila, Thanks for the information. We are currently storing xml code in ntext columns. While migrating to SQL 2008, I want to change them all to different datatypes (since...

I'll check and surely let you know the outcome....

Thanks mate. Seems promising. Will try and let you know. However, the sizes of both tables I've already mentioned in earlier posts. Both Table A and B contains around 6.5...

Any suggestions ???? Eagerly waiting your advice... Already tried and tested lots of things but query taking around 3:15 mins at best....

Here they are...

Here's the execution plan.....

For more information, I took help of sys.dm_db_missing_index_details and other DMVs to check out for missin index details. Table A and B both contains around 64 Lac records and their...

Not possible to send execution plan here. I created two new tables form above ones without any indexes and tried after replacing those into the query for a common set...

http://www.sqlservercentral.com/Forums/Topic1037538-92-1.aspx

Hello Gail, I was going through the article. Its interestin topic as PKs and clustered indexes are the big factors for performance tuning.

I've a situation. I've one bg table A...

Thanks mate. Is there any document on recommended upgration/migration methodology or step by step guide ???

Though I'll make sure the same thing to test personally first...

Guys,

I am not a specialist but suggesting something different. Can you create another table with only searchstring column in it. I guess it will reduce the cost of whole table...

Thanks a lot. It worked within seconds. And now I also got the logic.

Can anyone help...? I've tried many things. Checked the rights provided to the logins, checked the DSNs as well.