Before you get a new box, there are some things you can do on your current box and software.

First, increase your RAM.  If any of your applications can use AWE...

Good point about TEMP.  We have created a TEMP directory away from the C: drive (Ours is P:\TEMP), and set the environment variables to use this for W2003, SQL Server...

You can be too proud or too ignorant to ask questions in a forum, but you can never be too good to ask questions.  Even if you end up posting...

Some things to remember when using the SQL Agent p(r)oxy account...  1) If the job owner is a SQL Sysadmin, all SQL and file access is done using the security...

I definitely agree wit hqcp77's posting.  In any job management tool (Control-M, Tivoli, Unicenter,etc), the object is to replace the SQL Agent batch processing so you get the benefits of...

As other people have said, you cannot stop a sysadmin doing whatever they want.

However, you can prevent them reading data that is sensitive, and you can find out what changes...

So, you are saying that a query run on a box with 1.6 Ghz of power runs slower than a query run on a box with 5,6 Ghz of power. ...

Remi is completely correct.  I have been working with relational databases for over 20 years and my advise would be the same as Remi's.

All that I would add is if...

Did you format your new disk as basic or dynamic.  If you used dynamic you may need to set the Bypass Traverse Checking right.

Either way, hopefully you will have checked...

You can lead a user to data, but you cannot make them think.

The issues around having Exchange and database servers distributed around the world seem the sort of problem you could get a good consultancy organisation to find a solution to...

If your organisation is affected by SoX or similar nlegislation, it may be worth checking with your Compliance people before using Simple recovery mode.  They may take the view you...

If xp_sendmail encounters a timeout when connecting to Exchange, xp_sendmail is disabled until SQL Server is restarted.

Outlook may work fine, but once xp_sendmail has been disabled, SQL Server needs to...

The root cause of the problem is a glitch in the mail processing.  There are a few KB articles about different variations of this, and how long the impact lasts...

When you use Windows authentication, the accounts must be set up as domain\ID in SQL Server.  This can easily be done in Enterprise Manager.

I strongly recommend that you assign your...