bmw110001 (9/29/2009)
it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea
I restate my first idea:
1) Hire a professional to help you tune the poorly performing database. It seems that you are not a SQL Server guru so I bet there are lots of things that could be improved. This is NOT a personal attack, just an observation based on years of experience.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service