this raises some interesting points :-

1. views can be bad for performance, the concept of putting a bad query into a view for simplicity to make the schema easy doesn't...

it can be a bit of a minefield with the different o/s versions and sql versions and sometimes sp's changing things too. I did note that somewhere in amongst the...

you're looking for a DBA !!

I figure you're asking us questions about the output of a monitoring tool. I suggest you either ask the vendor of your tool or get some appropriate training in the...

unless I'm mistaken sql server sp's are cluster aware so you apply them to the virtual server.

first off if this is a production system I'd either sack the windows admin who made the change or remove builtin admins access to the sql server ( although that...

ask whoever set the traces ?

remove or re-configure the alert. Why on earth would you want to raise an alert on an idle cpu state ?

the question is too vague and as such does not indicate any particular issue. The o/s , sql edition, setup and hardware might be useful to know. Also exactly what...

chris - you can't enable awe without the /PAE switch. Perhaps you intended to say don't use the /PAE and /3GB switch on a server with 4GB of ram ?...

a profiler trace would be your only real option, unless you write an audit table update into each object , you can use something like this in a proc

• insert into...

as John says, you need a new virtual server, clustered instances don't add quite the same as a non clustered environment.

I'm thinking back to running an active active cluster and...

apply last backup and roll logs forward until point in time / last log backup.

Failing that you may be able to recover using a log explorer type program, which you'll...

I'm not in a position to check this one out. When sql server was on w2k I'm sure I tried this and it didn't work. As far as I can...

yes you can, sorry can't remember where/how but I had a book on programming AD and exchange which showed how to do this. you might want to search under ldap.