Again a good suggestion and again (unfortunately) a limit of my ERP Software. The table constraints are all based on unique indexes (on all 6000 tables) without a single...

Hi, I appreciate the comment - I am not saying that i want high CPU all of the time but my issue is that I never see any period of...

I have done all i can with indexing and tuning. I have even offloaded the reporting to another instance and other servers to keep the hardware priority with the...

Thank you for your replies they are very helpful. I agree that the best way to go forward will be SQL 2005 with a compaitibility mode. The only...

Thanks for the helpful replies. If you bothered to check out the link i sent you may see that the author of this article is quite reputable...