Also make sure that the Windows Firewall is disabled

I agree 100% with Kevin - the bottleneck will be with the drive speed. What I wouldn't give for an SSD.

Have you found a resolution to the "Failed to get MSFTESQL indexer interface for full-text catalog"

We were experiencing the same issue and found a KB article -

Boredom can lead to mistakes or a lack of concentration and performance issues. If you are not challenged you cannot grow.

By chance is there a third party application running a backup that you are not aware of - something like Tivoli or Symantec (both with SQL snap-in).

Some information got orphaned, take a look at the following:

--RUN AGAINST msdb database

select * from sysjobs --this will give you the job id

select subplan_id from dbo.sysmaintplan_subplans where job_id =...

Is rebuilding the master database an option available to you?

[/url]

You don't necessarily need to change the OS - you can uninstall the existing SQL and install SQL Server Standard (or whatever flavor you like). Also, personally I have...

Have you had a chance to look on SQL Server Central? The stairway series is quite nice - http://www.sqlservercentral.com/stairway/72399/

You should be able to do a Google search for what you are looking. I found the following

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Take a look at the sys.databases table in master

Take a look at this article by Microsoft, it makes mention of the registry (in one instance I had to hack it to get a complete uninstall to complete).

What Gail is trying to say is that by auto growing 10% each time, the size will grow. As an example - if you have a 100 GB database...

Three plus year old post - SP4 was not available at the time of original post.

Do you mean you have the SQL application installed on D:\ or just the database .mdf and .ldf?