Did you try Tools -> Options -> Environment -> Fonts and Colors?

Hi,

I can provide some input to 1 and 2

1. I think so- SQL 2008 is stable and reliable from my experience at SP1

2. We have gone live with a SQL...

I agree with you Warren, but not many Windows admins defrag servers anyway (from my experience). They suggest a rebuild and restore from tape- if anything. All defrags (database or...

Thanks for the correction Ed- that's why I'm a DBA and not a windows admin 😉

ps. I have heard conflicting stories from Microsoft engineers regarding fragmentation of database files. We...

Are you sure it's not tape backup (or SQL) agent locking the files? They tend to do that from time to time.

Diskeeper probably works in a similar way to the...

You could also use Diskeeper (and others) to defrag files whilst in use...

This has been resolved. Was a security issue with a 'locked down' server, where SQL Diag didn't have rights to write the trace file to the directory...

I'm not sure I agree with that...

If the op leaves the database in 2000 compatibility mode, everything should work (including deprecated code). It has worked that way for us in...

Change the password?

and don't allow hard coded connection strings...

The history of Tuning Advisor executions is stored in the DTA_ tables.

I have seen MSDB grow beyond 10Gb with much DTA activity...

As the poster above mentioned, often those errors are flagged as SQL is trying to write to the particular database and has insufficient disk space to write even one additional...

Have a look at tables in msdb to see if any are exceptionally large...especially if you have been running DTA on this server, it is possible that msdb has grown...

Our auditing team uses imperva to audit SQL Servers.

The only thing I don't like about some of these auditing tools is that they use profiler trace to capture audit...

My attitude is too many servers are procured with insufficient memory (and disks).

The 2Gb standard server specification to run the operating system/drivers/antivirus/SQL Server etc is insufficient in my opinion. You...

Yes- it works fine.

All our developers use 32 bit SSMS to connect to 64bit SQL 2008 server.