I am no code guru myself thats why I think I have a much larger problem then just the sql database itself.

Thanks for your input I have been profiling the server for about a month now at different times and for different length of times no indexes are recommended and as...

Thanks Guys for all your recomendations.  I have pretty much narrowed the problem down to exsive indexes that are slowing the updates and inserts to a crawl which then has a...