Hi,
I am sorry to say that there may be some other problems too like locking mechanism etc... as this is performance related problem. Just check out sp_who2 while this is executing. And also are there any backup jobs or any other jobs executing in the background while this is happening. Studying execution plan will take more time but let me tell you this is the best one for beginners
http://www.sqlservercentral.com/articles/Administering/executionplans/1345/
http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p2.aspx
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]