Thanks for your help every one, I have applied what you all wrote and it seems to be working. Just one more question:

I was using SQL Profiler based on a workload that I gave it. The indexes that it had put in there were different than what really are making the difference. Is there a specific way to use to profiler, I used the workload tracer with three days of routine work load.

Am I using it right..?

Thanks