I understand. Let me arrange the plan and query. I can't add all the data as it is big enough but will see If I can reproduce it with minimum...

Thanks so much for taking out time to write this for me.it really will help me to go in right direction. I'll spend some time to analyze this approach and...

Thanks Bill for giving some really nice alternatives. For point 3 , we have already increased timeout to some 60 secs. I will try point 1,2 and 4.

POint 5 probably...

Hi Eirikur

Let me try to answer your questions:

Is the total number of columns 20?

No, it is somewhere between 20 and 30. But the user has the flexibility to choose any...

Just in case if it helps anyone, we did the upgrade of subscriber by stopping the Distributor agent for all publishers and it worked just fine. Stopping log reader agent...

Thanks for an elaborated answer Jeff. I surely will look into the points you mentioned.

Thanks for reply Eric but I actually wanted to know what are the tasks which can be performed by sysadmin only

like only a sysadmin can create a linked server. So...

Wise words Gail! Actually the frequency of inserts is so high, that even the extra wait of few ms starts getting reflected in a third party tool we are...

Thanks for responding Jeff. Unfortunately I can't stop the inserts any time as it is live table. Inserts happen all 24 hours. But we have to archive data as well...

Hi Gail

Thanks for your reply. But Microsoft suggests that having multiple files is good without the mention that they need to be on different drives. I even read a post...

I think I should try WT (with tools). trying that.....

really?? I already tried installing 2012 express from this file :ENU\x64\SQLEXPRADV_x64_ENU.exe( mine is 64 bit). This was the biggest file with 1.3 GB size. So I though it will have...