Thanks Adriann for your precious time! Last time I had this issue I did update statistics and it worked. I'm not sure we have any unique column. So, I'm planning to create non-clustered index on one of the column. I'll update on this post. In the meantime, if anybody has been through this...

Thanks Satya and Adriaan, I really appreciate you guys precious time to help me out. Let me make myself more clear. Actually, I was just explaining about the process. However, the problem is in SQL 2000 since this occurs after everything is loaded on staging table. I checked for the blocking using SP_WHo2...

Hi everybody, I have a DTS package that runs every morning to import data to SQL 2000 tables from Sybase. I'm having problem with one of the package from this friday. The scenario is as follows: The source for the DTS package is a view. The view does the select from the only one table of around 34...

Hi All, I spent considerabale amount of time on tuning the following query.I tried to remove temp table with derived table,but while executing, i was getting errors. I dont have any idea about tuning on Cursors in the below query.My major concerns are, how can i replace cursors and temp tables in the...