Do you have enough space in your log file? does the drive your log file is located have enough space for log file growth? shrinking logs a lot of things
I updated the statistics on all related tables but nothing changed. The main query is like this: select feild1,field2,... from T1 inner join T2 on T1.key=T2.key inner join T3 on...